Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

XLS to SQL [help me plx]

Name: Anonymous 2007-02-14 16:04

im looking for a FREE program that will convert an excel spreadsheet to sql for easy uploading / updating.

ive tried the csv method and works fine for numbers and short text. but a lot of my cells contain commas and other weird characters.

anything free out there?
or any other method?

Name: Anonymous 2007-02-14 19:14

>>2
Ah, wait, I hadn't read your post. I just saw the words "excel", "sql" and "csv" at a glance.

Still, no problem with commas. Just export to CSV (careful in Excel 2003, I've heard Microsoft fagged up CSV export and hid it somewhere because people were using it to make Excel data portable). The CSV file should enclose shit with ", and use \ to escape. , to separate fields and EOL to separate rows. MySQL supports that.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List