Importing data into a DataWindow object
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 Exporting and Importing XML Data.