Sorry...
Wrong approach!
Use safe class:
SqlBulkCopy[
^].
How to use it (step by step)?
1. Create
connection [
^]to MS Access database
2. Load data from MS Access database into
DataTable[
^]
3. Disconnect MS Access database (
do NOT remove datatable object!)
4. Create
connection[
^] to MS SQL Server database
5. Use datatable object within
SqlBulkCopy.WriteToServer[
^] method to copy data between databases
6. Disconnect MS SQL Server
That's all!