HELP putting excel into table with phpmyadmin

boraman

Hi guys,

First off, I will say that I already searched for over an hour on this subject and tried EVERYTHING I could think of to get this working, no luck.

I have several excel files that I need to import into a table. I use PHPMyAdmin.

I know the whole insert data from textfile deal and I know you must convert to a CSV but something is not working, no matter what I seem to do, I get the following error <b>"File could not be read /tmp/phpN2DCgh
"</b>

I thought maybe it was my file that wasn't working but then I inserted a record in the table and exported into CSV and still no luck, same error.

I think the problem has to do with the settings I am choosing under the insert data from text file thing.

Here is the test record I am trying to insert for reference: "3434","dfdf","45454","dffd","dfdf","dfdfdf","2005-01-12","dfdf","343434","34343434","3.33","2000-11-11","sdsdsd","sadsadsad","23334343434","0000-00-00","22","kalamazoo","notes","33"

And the field names I have are: address city zip twp mortgagor mortgagee date_recorded assignee price SEV rate redempt_date legal contact number newspaper_date issue county notes parcID

The settings I am choosing are:

Fields terminated by: ,
Fields enclosed by: "
Fields escaped by: \
Lines terminated by: \r\n
Column names: address city zip twp mortgagor mortgagee date_recorded assignee price SEV rate redempt_date legal contact number newspaper_date issue county notes parcID
LOAD method: ...DATA

Does anyone who has imported a CSV before know what I am doing wrong?

Thanks!

jackiw

Lets pretend that your table has the first columm named ID and it's a primary key auto_increment. Then for you to import the CSV data into your table, you have to put "", in front of each row that you have on your file, this way it will auto increment the ID number. I've tried it myself and works.