Importing a DB 1

[Gatorajc]

I need to import some data from an excel spreadsheet. Is there anyway to do this besides using command line? I am using MYSQL 3.23 on WIN NT. AJ
I would lose my head if it wasn't attached.

 

[sleipnir214]

There's a MySQL app called EMS MySQL Manager. (

http://ems-hitech.com/mymanager/).

It runs on Win32 and can connect to your database, open the Excel spreadsheet and dump the data in. It will ask you how to map the columns from the spreadsheet to columns in your database.

It's not freeware -- a single-user license is $95. There is a 30-day demo, though.
Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!