trsafering access record in sql data base...


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

Hybrid View

  1. #1
    Join Date
    Mar 2005
    Posts
    37

    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:

    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
    Dec 2006
    Posts
    13
    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.

    Cheers.

Similar Threads

  1. NullPointerException when reading text file
    By Andrew McLellan in forum Java
    Replies: 3
    Last Post: 05-09-2001, 06:34 PM
  2. Data transfer from access to sql
    By Adolfo in forum Database
    Replies: 4
    Last Post: 04-19-2001, 06:36 AM
  3. Data Access Pages to Emulate Website on CD
    By John Simmons in forum Enterprise
    Replies: 0
    Last Post: 02-09-2001, 01:42 PM
  4. creating data base with microsoft SQL 7.0
    By jose in forum Database
    Replies: 1
    Last Post: 01-08-2001, 02:22 PM
  5. Re: ODBC error
    By Devaraj in forum Enterprise
    Replies: 0
    Last Post: 05-11-2000, 01: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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