| Home | Previous Lesson: Data Manipulation Next Lesson: Exporting Data |
At the moment PowerBuilder supports importing data from two file formats, namely tab delimited text and the .DBF format. However, it is likely that in future releases more file formats will be supported.
To import data, go into the data output sheet and select Rows > Import from the menu.
For each row you import, PowerBuilder creates an INSERT statement and when you select Rows > Update menu option, it sends those statements to the database. This is a logged operation, so if you are importing large amounts of data, first consider the memory on your local machine and the log space that would be required for the database. If you are connected to SQL Server, you should consider using a Bulk-Copy Program (BCP).
When the changes are saved, data will be written to the database. If the table has a unique index and duplicate data is imported, PowerBuilder doesn't display error at the time of importing. However, the connected database will generate error while saving the changes back the database.
| Home | Previous Lesson: Data Manipulation Next Lesson: Exporting Data |