DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    trsafering access record in sql data base...

    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:


    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
    Dec 2006
    Hi, you can link external tables (via ODBC, ADO, etc.) in access via the "Link" command in the database view (my copy of Access is not in English, so I don't know the exact name of the command, so it could be named differently). With your external table linked you can perform append and update queries on it from your access tables. This however works only if the operations you need to perform on the records can be done with Access querying functions (Iif, etc.).

    If your export requires some other operations that cannot be performed from within access, you can export the table to a CSV or similar file, perform the operations with an external tool, and reimport it back into access, where you can append it to the external linked table.


Similar Threads

  1. NullPointerException when reading text file
    By Andrew McLellan in forum Java
    Replies: 3
    Last Post: 05-09-2001, 05:34 PM
  2. Data transfer from access to sql
    By Adolfo in forum Database
    Replies: 4
    Last Post: 04-19-2001, 05:36 AM
  3. Data Access Pages to Emulate Website on CD
    By John Simmons in forum Enterprise
    Replies: 0
    Last Post: 02-09-2001, 12:42 PM
  4. creating data base with microsoft SQL 7.0
    By jose in forum Database
    Replies: 1
    Last Post: 01-08-2001, 01:22 PM
  5. Re: ODBC error
    By Devaraj in forum Enterprise
    Replies: 0
    Last Post: 05-11-2000, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.