Assumig i have acces my_db.mdb and my_mdb.mdf (in instace named DVD377-14D9E48C\SQLEXPRESS)
Access mdb have table named my_table with:

field1
field2
field3

i have same table named my_table in sql instance with same named record and same property of access mdb

i want to transfer all record from access table in sql db, record by record...

similiar:

rs.recorset1 of access in rs.recorset1 of sql db
rs.recorset2 of access in rs.recorset2 of sql db
rs.recorset3 of access in rs.recorset3 of sql db


...ecc

record by record becose during the export from access to sql i make various operation on single record...