PDA

Click to See Complete Forum and Search --> : Access to SQL Server

kalvin
October 30th, 2004, 09:18 AM
anyone know how to transfer data from MS Access to SQL Server without having to re-enter everything?
Davey
October 31st, 2004, 05:57 AM
You can use the DTS Wizard in SQL Server and pull the data out of access into SQL Server.
jp140768
October 31st, 2004, 02:50 PM
From Access, you could link a table to the SQL table, it will be given a slightly different name to the one in Access, then using an append query you could copy the contents of the Access table to the SQL one.

HTH