批量转换视觉foxpro dbf表到csv [英] Batch convert visual foxpro dbf tables to csv

问题描述

我有一个巨大的视觉foxpro dbf文件集合，我想转换为csv。
（如果愿意，您可以下载一些数据。点击2011年的交易数据链接，准备等待很长时间...）

I have a huge collection of visual foxpro dbf files that I would like to convert to csv. (If you like, you can download some of the data here. Click on the 2011 link for Transaction Data, and prepare to wait a long time...)

我可以用 DBF View Plus （一个真棒免费软件实用程序），但将它们导出到csv每个文件需要几个小时，我有几十个文件可以使用。

I can open each table with DBF View Plus (an awesome freeware utility), but exporting them to csv takes a few hours per file, and I have several dozen files to work with.

有一个像DBF View plus这样的程序，它允许我设置一批dbf-to-csv转换来运行过夜？

Is there a program like DBF View plus that will allow me to set up a batch of dbf-to-csv conversions to run overnight?

/编辑：或者，是否有一个很好的方法来将.dbf文件直接导入SQL Server 2008？因为每个文件只是同一个表中的记录的一个子集，并且应该具有相同的列名。

/ Alternatively, is there a good way to import .dbf files straight into SQL Server 2008? They should all go into 1 table, as each file is just a subset of records from the same table and should have all the same column names.

推荐答案

在这种情况下，SQL-Server我认为有能力连接到foxpro表。我不知道如何，因为我从来没有做过最近（上次使用SQL-Server约8+年前）。我确定还有其他线程可以指向将SQL-Server连接到VFP。

In that case, SQL-Server I think has a capability of connecting to foxpro tables. I'm not exactly sure how as I've never done it recently (last time using SQL-Server about 8+ yrs ago). I'm sure there are other threads out there that can point you to connecting SQL-Server to VFP.

我快速搜索，看到此主题

此外，您可能需要最新的OleDb提供程序建立连接，我也发布在一个线程这里。此线程还显示您可能需要从SQL Server的连接字符串信息的示例。数据源信息应指向找到.DBF文件的PATH，而不是要尝试连接的.DBF的具体名称。

In addition, you might need the latest OleDb provider to establish the connection which I've also posted in a thread here. This thread also shows a sample of the connection string information you may need from SQL-Server. The data source information should point to the PATH where the .DBF files are found, and not the specific name of the .DBF you are trying to connect to.

希望此帮助你。

这篇关于批量转换视觉foxpro dbf表到csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！