I have to convert MS Access database to a SQL Server database. Can anyone tell me how to do that. Shall I use DAO for it, or there is another way to do it.
Printable View
I have to convert MS Access database to a SQL Server database. Can anyone tell me how to do that. Shall I use DAO for it, or there is another way to do it.
Hi,
i think this is the easiest way to get data from Access to SQL-Server (if you do it once!):
1. create the table on SQL-Server (using "create table" ;-) ).
2. open Access an make a reference to this table (File->external data->reference/connect... [this is trancelated, can differ)
3. open the access table and select all rows
4. copy them
5. insert it into the refereced table (this MAY take a MINUTE... ;-) )
Bye
O.K
Another way to do this: use the File/Export feature of Access. Choose to save the exported file as type 'ODBC Databases'. Then use your ODBC connection to the SQL database. This will create the table for you in the specified database. The only problem with this is that the export function defines the table for you, so you can't control what the SQL table looks like.
To do it programmatically, I would recommend ADO. Then you can set up the SQL table however you want, and format the data however you want.
Good luck!
katlaw