[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.
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
More information about the thelist
mailing list