load .tab file

[#1]

When I load an *.tab file into QV, not all lines will be loaded (about half of the lines, file is about 120.000 lines long). When I import this file into Access and export it as .txt file and load this txt-file into QV ... all lines will be loaded. Has anyone the same problem and / or has anyone an answer to this problem?

Liesbeth

[erichshiino]

Hi, do you get the lines at the top, bottom or at randon?

Do you get the right values on the fields?

Can you share a piece of your file? and the script you are using to read it?

I think it maybe some script parameter  ...

[#3]

When I import the table file all looks well, all values seem to be at the right fields...

I attached the two files you asked for in my initial question.

[kji · Accepted solution]

Set Quoting to standard (default is MSQ), this will disable records over multiple lines.

The problem is an unbalanced " sign, making qlikview interpreting the rest of the file after that as 1 record.

[#5]

Ah, yes, that helps. tnx