Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: trsafering access record in sql data base...

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


    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...


    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


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

  2. #2
    Join Date
    Jan 2007
    California, USA
    I would think you could attach the SQL Server table to your Access database, then open both the Access table you want to read (copy) from, and the SQL Server linked table as Access RecordSets. Then you can loop through the Access table recordset, one record at a time, do the various operations necessary, then write the completed record to the SQL Server linked table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts