Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    115

    Unanswered: import data from sybase using VB code

    pls advise how vb code to import sybase data into access database

    regards

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I have no experience getting Sybase data into Access. But the procedure is the same for all databases. First you are going to need and ODBC driver for Sybase. I did a quick search on Google and saw several promising links. Then you would use the ODBC driver while you Link To, or Import the Sybase data using File/Get External Data. The wizard will walk you through the steps.

    Once you have tested everything manually, you can used the Docmd.TransferDatabase, along with an appropriate connection string (see hint below) to automate the import/link.

    HINT: Manually link to the Sybase data using the wizard. When you have a link object setup in your Access database, choose to design the table. You will get a warning, ignore it. When you see the fields listed, right click anywhere in the white and choose Properties from the COntext Menu. In the Description property you will see the Connection String that the wizard created to make the link to the Sybase table. Copy and use that string when you are automating the Link/Import.

Posting Permissions

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