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 20:14

>>3

I thought the CSV standard used a double-double quote to escape an embedded double quote.  No other character needs escaping since the double quotes delimit the fields.

http://en.wikipedia.org/wiki/Comma-separated_values

Wikipedia seems to agree.

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