On 13/06/2008 01:11, Keith Clark wrote:
I seem to be having problems importing a file that I've saved as a .csv
file from calc. I'm using phpMyAdmin and it seems to have errors in
the .csv file import. I look at the reported line numbers with the
errors and nothing is wrong. I don't know if it is a problem with the
file generated with Calc, or a problem with phpMyAdmin. Any ideas on
how to check this problem out?
Keith
Look at the file with a *text* editor - on Windows, Notepad; on
Linux/Mac, not sure.
Seems to me there are 2 possible problems:
1. A .csv file consists of a series of "fields" (one per Calc column if
it came from Calc). Each field is separated from the next by a
"delimiter" character of your choice. The usual is the comma (hence CSV:
Comma Separated Values). I have no idea what delimiter phpMyAdmin
expects but you must ensure that whatever it expects is what you choose
when you save the file from Calc.
2. Calc, like other programs with the "Export/Save as CSV" will enclose
text values in quotes. With Calc you can choose single or double quotes
and you need to ensure your choice is compatible with what phpMyAdmin
requires.
If this doesn't help please explain in a lot more detail the errors you
are seeing.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
