You've got few ways to resolve your issue.
A. download and install
Microsoft SQL Server Migration Assistant 7.10 for Access[
^]; Then follow the steps of wizard;
B. you can use
BULK command[
^]
C. you can use
SQLBulkCopy class[
^]; It's quite easy:
1. Connect to MS Access database
2. Create command to get corresponding data
3. Load data into DataTable
4. Close connection to MS Access database
5. Connect to MS SQL Server
6. Copy data from datatable to proper MS SQL Server table
7. Close connection to MS SQL Server
That's all!