Question for Manesh about Dataform Wizard article

Question

Manesh, In your step by step article on using the dataform wizard, you display a screen that you say is "most important." It is after the dialog where you choose the tables and columns to display on form. My "Next" button is ghosted out and I cannot get to that final screen to choose how to display the form. "Cancel", "Back" and "Finish" are active, but not "Next." I am using Visual Studio .NET 2003 EA v7.1.3088 Thank you!

Answer 1

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.

Answer 2

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

Answer 3

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