David Please also have a look at MYdbPAL for MySQL. Freeware again - this will sort out any schema conversions you might need - auto corrections. Plus you can model the schema.
MDB conversion is shown in the tutorials. Tim Hayes -----Original Message----- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: 30 March 2005 06:23 To: mysql@lists.mysql.com Subject: RE: Need Help with 813-MDB File 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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Tuesday, March 29, 2005 11:29 PM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]