Hello All
I would like to import a table from one database to another using DB toolbox.
I do not want to import all data to LV and then save them to another database. Instead I would prefer to use SQL syntax.
Does anobody know how to write SQL command to import whole table from one database to another?
I have found in some SQL manual that INSERT INTO should work, but JET4 returns an error that table (e.g. c:\mydatabase\table1) can not be found.
Thanks in advance
Pawel
