User Profile

Collapse

Profile Sidebar

Collapse
jun
jun
Last Activity: Nov 3 '06, 05:29 PM
Joined: Nov 3 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jun
    replied to Insert records into local access table from external DB
    in Access
    How does a linked table work, after linking the table, if I delete the linked table from access, does it delete it from the external database too or is it just a view of the table present in external DB?...
    See more | Go to post

      Leave a comment:

    • jun
      started a topic Insert records into local access table from external DB
      in Access

      Insert records into local access table from external DB

      Friends,
      I need to insert around 13000 records from a sybase external DB to one
      of my local table in access. I have the connection string set up and
      everything works fine except for the execution time. It takes a lot of
      time to populate the local table because I have a recordset variable
      which loops through the 13000 records returned from the ADODB
      connection object and inserts one line after the other...
      See more | Go to post
      No activity results to display
      Show More
      Working...