Is there any free tool to convert a file with more

问题:

I need to convert a very large file from DBF format to CSV format. I have tried Microsoft Excel to do the job, but the problem is that I cannot see more than 65500 registers when I open and export the file.

Microsoft Access couldn't open the file, too.

I have found on google some shareware tools, searching for "DBF to CSV". Have you tried any of these with very large files?

Also, any solution that could export to mysql or postgresql database formats will be welcome.

Thanks in advance for your responses, best regards,

回答1:

https://github.com/SocialExplorer/FastDBF

"Also included here is a small utility that reads DBF files and outputs CSV files! "

回答2:

go to http://www.the-oasis.net/ftpmaster.php3?content=ftputils.htm

look for this file dbx130.zip

Bytes: 125,478 Date: 1993-03-22

dbMAX is an xBASE utility that will allow complete multi-user access
to any xBASE databases and indexes. The program uses a CUA-type menu
system with Brief(R)-style hot keys and can browse databases in up to
250 moveable, sizable windows. Almost every Clipper(R)/dBASE(R)
command is available, allowing dbMAX to replace the dBASE
Assist/Control Center or Computer Associates' DBU utility. dbMAX also
has a partially open architecture, allowing programmers to create
their own menus and operate on dbMAX internal data structures.

this utility has a dos ui but it allows you via the Copy function on the menu to export entire dbf tables in SDF or CSV format. I personally know that it can handle a file with 3.8 million rows so it should be able to handle your table.

回答3:

Use OpenOffice - Its free and can handle a lot of rows. With that many rows, you might need to split the file and then convert the pieces and then reassemble.

回答4:

OpenOffice 3.0 Calc maxes out at 65K rows. I tried importing a large DBF into OpenOffice 3.0 Base but it handed the job off to Calc :-(

Alternative: if you have Python 2.4 to 2.6, I can send you a copy of my soon-to-go-public DBF-reading module plus a DBF-to-CSV script. To get my e-mail address, search for "John Machin xlrd" [xlrd is my Excel XLS-reading package].