[thelist] excel migration to database

Ken Moore cor412 at hotmail.com
Fri Oct 10 08:48:00 CDT 2003

Hi all,

Another idea is to export to Access. Then you can 1) Attach from MtSQL using 
ODBC 2) Export to MySQL format 3) Use SOL commands to convert.


>From: Simon Willison <cs1spw at bath.ac.uk>
>>I am migrating several hundred excel spreadsheets to MySQL, a time
>>consuming process. Is anyone aware of a tool where I can batch save all of 
>>the sheets as tab delimited files?
>Doesn't Excel have a "save as CSV" or "export to CSV" option?
>An interesting alternative method is to dynamically construct SQL insert 
>statements using Excel formulas. It's years since I last used a 
>spreadsheet, but the basic idea is that you build a formula in a cell that 
>does something like this (pseudocode):
>= "insert into tablename values('" + escapeslashes(D4) + "', '" + 
>escapeslashes(D5) + "');"

Fast, faster, fastest: Upgrade to Cable or DSL today!   

More information about the thelist mailing list