Hi !
I'm trying build a tool that pre-processes an Access database and then exports the results to a SQL Server database.
I find it easier to work with SQL queries than to do line-by-line calculations in a DataTable, so the way I was thinking to go about it is to do all the number-crunching in Access, build the final table in there, and then insert the results of that table to my SQL Server DB.
Would it be easier to create from Visual Studio an ODBC linked table from Access to SQL Server and then use a simple INSERT TO query, or to load the data as a DataTable and then drop that into the SQL server database ? The name and location of the SQL Server database is a parameter in the tool, so I cannot create the link "by hand".
I don't really know how do to either, so any help would be fantastic !
Thanks
I'm trying build a tool that pre-processes an Access database and then exports the results to a SQL Server database.
I find it easier to work with SQL queries than to do line-by-line calculations in a DataTable, so the way I was thinking to go about it is to do all the number-crunching in Access, build the final table in there, and then insert the results of that table to my SQL Server DB.
Would it be easier to create from Visual Studio an ODBC linked table from Access to SQL Server and then use a simple INSERT TO query, or to load the data as a DataTable and then drop that into the SQL server database ? The name and location of the SQL Server database is a parameter in the tool, so I cannot create the link "by hand".
I don't really know how do to either, so any help would be fantastic !
Thanks