Import Access Data to SQL Server Database in code
Posted on 2013-07-01
I'm migrating an application from using a Microsoft Access database to a SQL Server database. The applications needs, though, to be able to import data formerly saved in the Access database into the new SQL Server database. I did some searching, but couldn't find the syntax for doing so.
The "easy" way would be to import the data into a datatable in C# and then save it to the SQL database, but that's slow when importing even 10,000 records. Some of the tables have hundreds of thousands of records, so I'm looking for a bulk import statement.