Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Tampa, FL (USA)
    Posts
    9

    Unanswered: Accessing a .dbf file in SQL Server 2000

    I am new to SQL Server 2000, and anxious to get started. I'm beginning with a project that will use a file saved in the .dbf(dBase) format.

    I looked in the Books on Line under 'OLEDB Provider' and didn't find any help about dbf files. I did use the 'OLEDB Provider for Jet' example to create a linked server that accessed an Excel spreadsheet.

    Can someone give me some pointers in accessing my dbf file in SQL Server 2000?

    Thanks for any help.

    Randy

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    you can create an odbc datasource and then set up a linked server with the 'ole db for odbc' driver. See in books online for more info.
    Johan

Posting Permissions

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