Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 21, 2006, 9:15 pm
rate this thread
Re: city state database
Data for city/state/country/zip codes etc., change so frequently that it is
best to get the data from a commercial product, including a subscription to
updates. Otherwise your database will be outdated within a month. There
are numerous commercial providers, for example:
Price: 12 month subscription for $39.95. In MS Access, MS Excel, and CSV
This is just the first such vendor that came up in a Google search. I don't
know how many others there are, or whether this is the best price. But I
would assume that any better price is at most $39.95 better than this one.
MySQL AB offers a tool called Migration Toolkit, but I can't find any
reference to .DBF support in its documentation.
Intelligent Converters has a product they call MySQL Migration Toolkit that
says it converts .DBF to MySQL databases. Price: $89.
EMS Software Development has a product they call EMS Data Import for MySQL
that also says it support import from .DBF files. Price: $45 for Linux, $65
There are probably others. I found these by a Google search for keywords
"mysql migration dbf".
You could also convert the DBF file to CSV using any number of free tools
(Google for "dbf csv convert") and then use MySQL's builtin LOAD DATA INFILE
statement to read the CSV.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum