Thanks for all the tips. I was able to import it with Navicat. In fact, I was amazed at how smoothly it went. I think it imported about 30 separate tables - nearly 4 million rows - before Navicat froze. But I was working on some other programs and probably ran out of memory.
It recorded over 8,000 errors - duplicate keys, etc. - but most of those seemed to be associated with viruses (REAL viruses, not computer viruses), which I'm not concerned about. Thanks again. --- "Berman, Mikhail" <[EMAIL PROTECTED]> wrote: > Is there a description of tables anywhere on CD-ROM > for Access database. > > Mikhail > > -----Original Message----- > From: Rhino [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 9:10 AM > To: David Blomstrom; mysql@lists.mysql.com > Subject: Re: Need Help with 813-MDB File > > > ----- Original Message ----- > From: "David Blomstrom" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Tuesday, March 29, 2005 11:29 PM > 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.) > > > Access is *not* a spreadsheet, it's a database. I > don't have it either > but > I've used 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? > > > Apparently, this is simple to do if you have Access; > I believe you can > just > do an Export to CSV (or other formats) within > Access. > > If you don't have Access, it could get somewhat more > complex depending > on > what tools you have. I was curious about your > question so I did a Google > newsgroup search using these three terms: > export MDB CSV > and got lots of hits. Some of them talked about ways > to read MDB files > without having Access, with Perl for example. So I > would suggest that > you do > a similar search, perhaps adding in some additional > keywords that > reflect > the tools/languages you do have, to find out which > ways are available to > you. > > > 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. > > > I have no idea if that can be done without Access, > let alone how to do > it. > > Rhino > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.3 - Release > Date: 25/03/2005 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ 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/[EMAIL PROTECTED]
