I have recently been working on a job with a client who gets their data from county data. The county data is contained in .dbf files. Every year the data is updated and my client will get a CD/DVD from someone containing the county data in .dbf format. Now the problem is that my systems have been developed to work entirely off of MySQL (that is not going to change) and I will not be working with this particular client in the future when he gets these annual data updates. So I need a PHP/Python/Ruby script that will convert the .dbf to MySQL once he has uploaded the pertinent .dbf files. All I need, is pointers to correct sources. I don't mind having to do a lot of coding. I just have absolutely no clue where to start. Thanks.

Re: PHP script for MS Access to MySQL 80 80

http://3d2f.com/programs/18-270-dbf-to-sql-download.shtml mAY HELP

woz gunna edit the text and put the capslock off, but didnt

Re: PHP script for MS Access to MySQL 80 80

This doesn't solve the problem. I wanted a PHP/Python/Ruby script that could do this automatically for my client. I can't use the command line version, because I don't have a windows box, I have a linux box.

Re: PHP script for MS Access to MySQL 80 80

From the linked site

You can run the program in a batch mode using command line interface. Besides, it includes a DLL which you can use from your own application.

This would imply you may be able to run this as a utility from your own script and then run the result script within My
SQL to generate the data.

Perhaps you should read more closely before replying so rudely to someone who was merely offering a suggestion to solve your problem.

Re: PHP script for MS Access to MySQL 80 80

whoops, I forgot to say that I am working on a linux box, not a windows. Sorry about that. I edited my answer.

Re: PHP script for MS Access to MySQL 80 80

runs very nicely under php, on apache, in my application immediately after the uploaded dbf is verified for structure.

Re: PHP script for MS Access to MySQL 80 80

Sorry, as soon as I saw that it was an exe rather than a php script I immediately wrote it off. Didn't realize that you could use it in a php script. The problem is that I don't have a windows box to run EXEs or DLLs. Thanks for the prompt response.

Re: PHP script for MS Access to MySQL 80 80

Perhaps you can provide the client a small utility program they could run on their end against the new files to convert and upload the data to your server, assuming they are running a Windows OS.

Re: PHP script for MS Access to MySQL 80 80

Yeah, I could. But my client is on Mac OS X 1.5, Tiger not Windows. And even if they were on Windows, I couldn't guarantee that it would stay that way. A PHP script that is platform independent would be a lot better.

Re: PHP script for MS Access to MySQL 80 80
Member Avatar

Not a script, but looks like free service - can't swear to it.

http://www.whitetown.com/converter/online/

They send you an email with a link to the converted db from 10Mb max dbf.

But this may be promising:

http://webscripts.softpedia.com/script/Database-Tools/dbf-Converter-1794.html

freeware php script transforms dbf to mysql

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.