>I am having difficulty inerting data into an Access 2000 database from SQL 7.0using only a SQL statement. I have transferred data from Access to Access using the " INSERT INTO [Microsost Access Database].[Table name] " format. This, however causes an error when switching to SQL. I get an "Invalid Object Name" and then it states the full path name like c:\Jason.mdb.Payments where payments is the table. Any ideas on this one?
Hi Jason,
You may link source table (tblSource) to destination Access database. Then try make table SQL:
SELECT tblSource.* INTO tblDestination FROM tblSource;
HTH
Igor Gelin
Database Developer