Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3 million rows so far, with
over 8,000 errors recorded.
But I'm going to download DB Tools, as I have frequent
need for data conversion tools.
--- "J.R. Bullington" <bullijr@stripped> wrote:
> DB Tools software will convert the file for you. You
> can download it at
> http://dbtools.com.br/EN/index.php. All you have to
> do is download and
> install the FreeWare version and then use the TOOLS
> > DAO Import Wizard.
> -----Original Message-----
> From: David Blomstrom
> Sent: Tuesday, March 29, 2005 11:29 PM
> To: mysql@stripped
> Subject: Need Help with 813-MDB File
> I acquired a CD-ROM that lists many thousands of
> animal species. The main
> file is a 813-MB MDB file.
> I'm not sure if it's a spreadsheet or database, but
> it's apparently designed
> to work with Microsoft Access, which I THINK is a
> spreadsheet. (I don't have
> I have just enough memory to open the file in
> WordPad, but it doesn't do any
> good because much of the data consists of
> unintelligible characters.
> Anyway, I need to figure out a way to import this
> monster into MySQL. Are
> you aware of any freeware programs that can open up
> files designed for
> Is there a way to convert a MDB file directly into a
> csv file, which could
> then be imported into MySQL?
> I'll probably eventually break it into sections. At
> the very least, I'll
> probably divide it between vertebrates (which I'll
> use the most) and
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around