Results 1 to 4 of 4

Thread: Import via ODBC

  1. #1
    Join Date
    May 2007
    Posts
    5

    Unanswered: Import via ODBC

    Is it possible to import tables into a SQL 2000 Database via an ODBC connection? The source files are dBase III (*.dbf) and reside on a different network from the SQL 2000 server. If so, would it then be possible to update those files via the same method?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    It depends. Are the source files in general visible via ODBC from your SQL Server?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    May 2007
    Posts
    5
    Yes, the source files are visible via ODBC from the SQL Server. My DB knowledge is limited to SQL Enterprise Manger and Query Analyzer, and after scouring the web I could not find a way to import data via ODBC using either of these.

    Thanks!

  4. #4
    Join Date
    May 2007
    Posts
    5
    I may have found the solution....

    1.) Set up a System DSN using proper ODBC drivers via ODBC Admin
    2.) Create a DTS task that imports data using ODBC driver and System DSN

    Almost sounds to good to be true. What do you think?

Posting Permissions

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