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
