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]
