[Solved] SET TABLE from .csv does not show all rows in table

[lnyork6]

I am creating a text table with the 29 varchar(50) columns and then set the table to "Invc.csv"

Code: Select all

CREATE TEXT TABLE "AutoInvc" ("col1" varchar(50), "col2" varchar(50), etc...)
SET TABLE "AutoInvc" SOURCE "Invc.csv"

But, table "AutoInvc" doesn't show all the data in "Invc.csv"
Every row in "Invc.csv" has the proper number of columns
It's not just cutting the data short, it's leaving out rows in the middle and including rows further down
If anyone has seen this before or knows why it might be doing this please let me know

Edit: I have tried my 'CREATE TEXT TABLE' with larger varchar and tried replacing some of the varchars with type double where appropriate and got the same results. Any ideas at all would be greatly appreciated. I have even tried setting a primary key, same results...

[lnyork6]

Stupid mistake... there were quotes in some fields.
solved with.

Code: Select all

SET TABLE "AutoInvc" SOURCE "Invc.csv;quoted=false"