Dear All,

I just want to enter the categories in Excel and then import it to the mysql dataabase. But when I try to import, it shows me the following error:

Error importing data: DBSQL (3780): Fatal Error: Unable to execute query: LOAD DATA INFILE 'categories.csv' INTO TABLE Category FIELDS TERMINATED BY '*' . Reason: at /home/asiaitrade/cgi-bin/links/admin/editor.cgi line 316 .

Does anyone know what's going on?



------------------
Bear EveryWhere

Hi,

I'm also using Excel to modify / add categorys. I had to export the excel data sheet in the *.csv format. The open the csv file with ultraedit and replace the ";" with "|". Be shure that the last entry in each row is not empty.

Regards, Alexander

Edit DBSQL.pm and change line 1210 from:

$sth->execute() or return $self->error ('CANTEXECUTE', $query, $!);

to:

$sth->execute() or return $self->error ('CANTEXECUTE', $query, $DBI::errstr);

That will at least tell you what the real error message is.

Cheers,

Alex