SqlDbx Forum

Dinesh Samson J

Guest

Export Import

i wanted to export the data of a tableA and import into tableB.

the structure of both the tables are same.

i used the "Export Data To" and saved the data as Result.tab.
then i used the "Import Data From" and selected the file.
The data is not importing, but the file gets opened in the Result window

i am using 3.28.1 (personal edition)

Monk

Member

Re: Export Import

In addition to this post: Also the same issue happens while trying to export and import XML's.

sqldbxhelp

Administrator

Re: Export Import

Data import into a table will not happen automatically.
When you select Import from file SqlDbx will open file in
a new Script Window with table name replaced by name
of currently selected table. Then you can execute script and
data should be imported.
There's currently no way to import data from XML file.

BoR4uN

Member

Re: Export Import

Hello! Can I export something from Excel to SqlDbx?

sqldbxhelp

Administrator

Re: Export Import

Yes you can.
http://www.sqldbx.com/Help/scr/html/ExportImport.htm