SQL Server 2005 importing/exporting DBF

[chatridge]

We have just recently started using SQL 2005 64 bit Enterprise Edition. We typically do a lot of import/export into/out of SQL to/from .dbf’s.

We noticed immediately when stepping through the Import and Export Wizard that there wasn’t an option for dBase files as the source or destination like there was in SQL 2000. We have been able to use the “.Net Framework Data Provider for Odbc” as a source from our local machines but have an issue with our third party (Extended Systems/Advantage Database) supporting the 64 bit platform so it hinders us from scheduling jobs on the 64 bit server that would use a dBase file as the source. I think that’s something we need to follow through with our 3rd party vendor.

As far as exporting to a .dbf file, we’ve searched around and can’t seem to find a solution or recommended procedure to exporting to a .dbf at all.

What is the recommended path/solution to import and export to/from .dbf files using SQL 2005.

 

[mrdenny]

Microsoft probably removed the foxpro driver from SQL Server. You may be able to find it on the Microsoft site (don't they own foxpro these days) or on a foxpro site (or dBase or what ever database backend you are using).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com