Access to SQL


Jul 3, 2004
Programming Experience
Hi I have written a new program in but now need to "upgrade" the data from their old system to the new one I developed. The old system used a simple Access database but heve been in use for years. My new system relies on SQL.

Does Anyone have any ideas on how this can be done. Or where I can go to gain more information.
I know you can create a link to the SQL server in the access database. From there I would use queries to copy the data over to the server.
The solutions above is a ljust a bit too much overhead you may want from an application.
since you were working with an access database everything ADO.NEt related should be from the OleDB namespace. Try replacing these objects with the corresponding objects from the Sqlclient namespace and don't forget to adjust the connectionstring to the SQL server!

Latest posts