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 Chapter 29, “Exporting and Importing
XML Data.”