List:General Discussion« Previous MessageNext Message »
From:David Blomstrom Date:March 30 2005 5:23am
Subject:RE: Need Help with 813-MDB File
View as plain text  
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.

Thanks.

--- "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.
> 
> J.R.
> 
> -----Original Message-----
> From: David Blomstrom
> [mailto:david_blomstrom@stripped] 
> 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
> it.)
> 
> 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
> Access?
> 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
> invertebrates.
> 
> Thanks.
> 
> 
> 		
> __________________________________
> Do you Yahoo!? 
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/ 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Thread
Need Help with 813-MDB FileDavid Blomstrom30 Mar
  • Re: Need Help with 813-MDB FileDaniel Kasak30 Mar
  • RE: Need Help with 813-MDB FileJ.R. Bullington30 Mar
  • Re: Need Help with 813-MDB FileRhino30 Mar
RE: Need Help with 813-MDB FileDavid Blomstrom30 Mar
  • Re: Need Help with 813-MDB FileDaniel Kasak30 Mar
  • RE: Need Help with 813-MDB FileTim Hayes30 Mar
RE: Need Help with 813-MDB FileMikhail Berman30 Mar
RE: Need Help with 813-MDB FileDavid Blomstrom30 Mar