Excel 2 CSV into phpMyAdmin

[carmoda]

is there a trick to saving Excel spreadsheets into a CSV format that will
import into phpMyAdmin without errors??

my CSV files have all kinds of errors, including loading the wrong fields.

I use Excel [office 2k version] on Win2k

phpMyAdmin 2.5.3-rc3 with MySQL 3.23.56
--
Regards,

Carmoda
iamcarmoda[remove-spam]@hotmail.com
====================================

[Thomas Kaarud]

"carmoda" <ia********@hotmail.com> wrote in message
news:3f**********************@news.optusnet.com.au ...

is there a trick to saving Excel spreadsheets into a CSV format that will
import into phpMyAdmin without errors??

my CSV files have all kinds of errors, including loading the wrong fields.

I use Excel [office 2k version] on Win2k

phpMyAdmin 2.5.3-rc3 with MySQL 3.23.56

Why not save the xls as tab delimited text (.txt) and use the mysql query:
'load data infile "file.txt" into table whatever_table;'?

Thomas.

[Thomas Kaarud]

"carmoda" <ia********@hotmail.com> wrote in message
news:3f**********************@news.optusnet.com.au ...

is there a trick to saving Excel spreadsheets into a CSV format that will
import into phpMyAdmin without errors??

my CSV files have all kinds of errors, including loading the wrong fields.

I use Excel [office 2k version] on Win2k

phpMyAdmin 2.5.3-rc3 with MySQL 3.23.56

Why not save the xls as tab delimited text (.txt) and use the mysql query:
'load data infile "file.txt" into table whatever_table;'?

Thomas.

[Nikolai Chuvakhin]

"carmoda" <ia********@hotmail.com> wrote in message
news:3f**********************@news.optusnet.com.au ...

is there a trick to saving Excel spreadsheets into a CSV format
that will import into phpMyAdmin without errors??

I'd say yes. If you have dates in your spreadsheet, you need
to format them as 'yyyy-mm-dd' before saving the spreadsheet
as CSV.

Cheers,
NC

[Nikolai Chuvakhin]

"carmoda" <ia********@hotmail.com> wrote in message
news:3f**********************@news.optusnet.com.au ...

is there a trick to saving Excel spreadsheets into a CSV format
that will import into phpMyAdmin without errors??

I'd say yes. If you have dates in your spreadsheet, you need
to format them as 'yyyy-mm-dd' before saving the spreadsheet
as CSV.

Cheers,
NC