Convertion of access database to sql using coding

Yes, as per Nitin, you can use SSIS which load the MS Access data to SqlServer.

If you are not comfortable with SSIS then create windows service which will run daily basis and do the job. Means everyday it will create an .sql file and then execute the sql file in server.

0

Nitin Sontakke10y ago

May be you should look into SQL Server Integration Services (SSIS).

0

Midhun Tp10y ago

Hi,

Please go through below thread-
http://stackoverflow.com/questions/10577237/ms-access-to-sql-sever-in-c-net

0