[thelist] excel migration to database

[Ken Moore]

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.

Ken

>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!   
https://broadband.msn.com