That's what I'd do (assuming there's no other programs available, but aint
sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with
LOAD DATA command
Sent on Jul 4 by jake williamson 28 to [EMAIL PROTECTED]
jake.w>
jake.w>
jake.w> hello,
jake.w>
jake.w> does anyone know how/are there any help programs to convert a excel
jake.w> spreadsheet into a mysql database?
jake.w>
jake.w> i can get the spreadsheet into access - would it be a case of i can then
jake.w> export that to mysql??
jake.w>
jake.w> any ideas oh guru's???!!
jake.w>
jake.w> cheers,
jake.w>
jake.w> jake
jake.w>
jake.w>
jake.w>
jake.w> 28
jake.w>
jake.w> 23a great queen street
jake.w> london wc2b 5bb
jake.w>
jake.w> t 020 7404 4828
jake.w> f 0870 164 3109
jake.w> [EMAIL PROTECTED]
jake.w> m 07931 507 442
jake.w>
jake.w>
jake.w> ---------------------------------------------------------------------
jake.w> Before posting, please check:
jake.w> http://www.mysql.com/manual.php (the manual)
jake.w> http://lists.mysql.com/ (the list archive)
jake.w>
jake.w> To request this thread, e-mail <[EMAIL PROTECTED]>
jake.w> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
jake.w> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
jake.w>
--
Sherzod Ruzmetov
[EMAIL PROTECTED]
http://www.ultracgis.com/sherzodR
---------------------------------------------------------------------
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
