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

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

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

Postby lnyork6 » Thu Jul 03, 2014 9:04 pm

I am creating a text table with the 29 varchar(50) columns and then set the table to "Invc.csv"
Code: Select all   Expand viewCollapse view
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... 
OpenOffice 4.1.0; split HSQLDB; Windows 8.1 - 7 - XP; MRI (debug)
lnyork6
 
Posts: 10
Joined: Wed Apr 23, 2014 5:48 am

Re: [Solved]SET TABLE from .csv does not show all rows in ta

Postby lnyork6 » Tue Jul 08, 2014 9:17 am

Stupid mistake... there were quotes in some fields.
solved with.
Code: Select all   Expand viewCollapse view
SET TABLE "AutoInvc" SOURCE "Invc.csv;quoted=false"
OpenOffice 4.1.0; split HSQLDB; Windows 8.1 - 7 - XP; MRI (debug)
lnyork6
 
Posts: 10
Joined: Wed Apr 23, 2014 5:48 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest