Connection provider for DBF file

Hi, I want to upload some DBF files to SQL server using Integration Service.
I already check every provider, but not found provider for DBF file.
Anyone can help me?

Hello,

When you create a data source, just use the provider "Microsoft Jet 4.0 OLE DB ..."

Then try a OLE DB Source or a Datareader source over the data source created.

Hope it helps

|||

Hi!

You can download the FoxPro and Visual FoxPro OLE DB data provider from msdn.microsoft.com/vfoxpro/downloads/updates. It works for all versions of Fox tables.

|||

Hi!

While the Jet OLE DB data provider will work for older Dbase IV formatted DBFs it will not work for Visual FoxPro tables. The FoxPro and Visual FoxPro OLE DB data provider works with all versions of FoxPro DBFs. As I said in my other post, it can be downloaded from msdn.microsoft.com/vfopxor/downloads/updates.

|||You're right.
Thanks a lot.