> We have a ton of data in MS Excel that I need to put into a Solaris
> based MySQL dB. The data needs input such that it correlates across
> several different tables (i.e. I can't just do table dumps). What
is
> the most efficient way to do this?
>
> Thanks,
>
> Valerie
Hi Valerie, My opinion would be to export the data as a .csv (comma
separated values) then write a perl script on the Solaris box to
import the data into the tables you have setup.
Ken
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
