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

    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.


  2. #2
    Join Date
    Dec 2002
    Antwerp, Belgium
    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.

Posting Permissions

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