[thelist] Copying tables

Chris Evans chris at fuseware.com
Wed Oct 25 10:35:12 CDT 2000

I know this is a FAQ but I can't find the answer.  I have an Access database
with about 50,000 records.  I have another table in the same database with
the same structure that is linked to a SQL server database.  I need to move
all of the records from the Access table to the SQL Server table.  Is there
a simple SQL statement to transfer data from one table to another?

I'm basically trying to upsize my Access table, but the Upsize wizard
constantly craps out.

Chris Evans
chris at fuseware.com

More information about the thelist mailing list