How can I copy an individual table from one microsift access database file to another?
Printable View
How can I copy an individual table from one microsift access database file to another?
You could try something like this (use the IN clause in your SQL statement). This example assumes that NewTable in the new database has the same structure as OldTable in the old database.
Code:Dim NewDB As Database
...
NewDB.Execute "INSERT INTO NewTable " _
& "SELECT * FROM OldTable " _
& "IN 'C:\Wherever\OLDDB.MDB'"