T Toast Mar 27, 2010 #1 Need vb script or macro to append a table in access database A to table of the same name in access database B
Need vb script or macro to append a table in access database A to table of the same name in access database B
D Douglas J. Steele Mar 27, 2010 #2 Actually, you don't need either. All you need is a query. Assuming the table already exists in database B, the SQL of your query would be something like INSERT INTO [;DATABASE=C:\Folder\File.mdb].TableName (Field1, Field2, Field3) SELECT Field1, Field2, Field3 FROM TableName This query would exist in database A, where C:\Folder\File.mdb is the full path to database B.
Actually, you don't need either. All you need is a query. Assuming the table already exists in database B, the SQL of your query would be something like INSERT INTO [;DATABASE=C:\Folder\File.mdb].TableName (Field1, Field2, Field3) SELECT Field1, Field2, Field3 FROM TableName This query would exist in database A, where C:\Folder\File.mdb is the full path to database B.
