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?