to import excel file into mysql

Question

Hey guys,

 

i want to import an excel sheet into mysql. there is no mistake in the code, but the excel can not been find. What i am doing wrong ?

  

this is my code:

 

create database if not exists ceribandin;

use ceribandin;

 

create table if not exists boats (

Begriffsbezeichnung INT NOT NULL PRIMARY KEY,

Wert VARCHAR (100),

Zustand VARCHAR (45),

Seriennummer INT,

Preis FLOAT);

Load data local infile "G\:PROJE, CERIBANDIN C#\ceribandinek.csv" into

table ceribandin.boats

fields terminated by ','

lines terminated by '\n'

ignore 1 lines

(Begriffsbezeichnung, Wert, Zustand, Seriennummer, Preis);