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

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

    Assumig i have acces my_db.md 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...

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    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.
    HTH,

Posting Permissions

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