SQL Server 2005 Import/Export to DBF | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2005 Import/Export to DBF

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#%92s. We noticed immediately when stepping through the Import and Export Wizard that there wasn#%92t 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#%92s something we need to follow through with our 3rd party vendor. As far as exporting to a .dbf file, we#%92ve searched around and can#%92t 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. Any help would be greatly appreciated.

Please post this under SQL server 2005 —————————————-