No qualified path for file: ***

[Anonymous]

Error while loading excel file

[Map]:

LOAD CountryId,

country,

Lat,

Long

FROM

[lib..//Xls\Map.xls]

(ooxml, embedded labels, table is Sheet1);

Path:

[ChennaiahNallani]

share error name or loge file

[Anonymous]

2018-03-01 11:56:44 0071 [Map]:

2018-03-01 11:56:44 0072 LOAD CountryId,

2018-03-01 11:56:44 0073 country,

2018-03-01 11:56:44 0074 Lat,

2018-03-01 11:56:44 0075      Long

2018-03-01 11:56:44 0076 FROM

2018-03-01 11:56:44 0077 [lib..//Xls\Map.xls]

2018-03-01 11:56:44 0078 (ooxml, embedded labels, table is Sheet1)

2018-03-01 11:56:44      Error: No qualified path for file: ***

2018-03-01 11:56:44      Execution Failed

2018-03-01 11:56:44      Execution finished.

[ChennaiahNallani]

check you connection

Long

    Description

FROM [lib://Connection/Telecom Data.xlsx]

(ooxml, embedded labels, table is [data dictionary]);

[YoussefBelloum]

Hi,

did you try another path just to test ?

create another lib (with a shorter path) and try to load from it.

did you opened the exact path on a "windows" window and found your file ?

[agigliotti · Accepted solution]

below syntax for connection string is wrong

[lib..//Xls\Map.xls]

please follow the wizard to insert string connection.

[Anonymous]

Hi,

Yes I  opened the path its correct.

I tried another path also.

[YoussefBelloum]

Like Andrea said here, did you wrote the lib line by yourself or did you use the the Wizard ?

[Anonymous]

Thanks

[pgambone]

What is the wizard?