Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Importing a CSV file, column headers not detected

Hello

I'm importing a CSV file into my QV app, but the column headings in the file are not being detected and QV is making default headings of @1 and @2.

I've attached the CSV file and the error. Does anyone know how to fix this?

Many thanks.

James

4 Replies
erichshiino
Partner - Master
Partner - Master

I think you just have to select the correct option for headers (Embedded labels) when you go through the wizard to import your file:

The script should look like this:

LOAD split,

     SplitName

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Regards,

Erich

christian77
Partner - Specialist
Partner - Specialist

Hi:

Labels.jpg

Not applicable
Author

Hi James

while importing data from table files in the file wizard type u'll get an option of label try to select embedded labels instead of default none/explicit labels ...

thanks a lot

Bradd

Not applicable
Author

Thanks for your answers! I had the same issue and it got solved.

Venkatesh