From Excel to MySQL with PHP query

[fabiuz]

Hallo,

I am in a little trouble to import data into a MySQL table from a XLS file.

My excel file has 4 colums with text only.
The problem is that colum 3 has something like:

LCD Monitor 15 " TFT ...

And seems that " is causing problems when I try to save the file in CSV format.
Yes, becaus I get something similar to:

;col_1;col_2;"LCD Monitor 15 "" TFT";col_4

and all these added " are not good for MySQL import function.

At the moment I have fixed by adding a couple of steps: import xls file to Access table and than out again in text format without any added " .

I hope there is an easier way...

The last thing I could tell is that also col 3 is set like "Text" ...

Help!

Fabio

[Anon]

Take Easy - The only thing that you have to do is assign the string to a var and before to pass the info to the db, or inside the function to pass the info, use the function -. stripslahes(string mystring) .- which strip the slashes. If u want more info, here you could find a lot of. http://www.php.net/manual/en/function.stripslashes.php