You can import and display data from an external source and save the imported data in the database.
To import data into a DataWindow object:
Select Rows>Import from the menu bar.
Specify the file from which you want to import the data.
The types of files that you can import into the painter display in the List Files of Type drop-down list.
Click Open.
PowerBuilder reads the data from the file into the DataWindow painter. You can then click the Update Database button in the PainterBar to add the new rows to the database.
Data from file must match DataWindow definition
When importing data from a file, the datatypes of the data
must match, column for column, all the columns in the DataWindow definition
(the columns specified in the SELECT statement),
not just the columns that are displayed in the DataWindow object.
For information about importing XML data, see Chapter 29, “Exporting and Importing XML Data.”
