Code: Select all
1: Table not found in statement [SET TABLE "contacts" SOURCE "contacts.csv;ignore_first=true;encoding=UTF-8"]
Important:
- I'm using OOo 3.2.0 on M$ Windows.
- In the attachment you can find Base and csv files.
Code: Select all
1: Table not found in statement [SET TABLE "contacts" SOURCE "contacts.csv;ignore_first=true;encoding=UTF-8"]
Code: Select all
CREATE TEXT TABLE "contacts" ("ID" INTEGER PRIMARY KEY, ........................)
Right, why I've to create the table from SQL command window? are there any differences between TEXT tables and table by design view?You probably created in design view.
No, you can create text table only in SQl command window.mbnoimi wrote:Is there any ability to create TEXT tables visually instead of SQL command Window?
If you want to connect extarnal csv table this is the way.Right, why I've to create the table from SQL command window?
No this problem still exist and I couldn't find any solution for itHas this been solved yet?
This is exactly what I need.If the writer only wants to remove duplicate rows from a CSV
As I mentioned in this link I couldn't open CSV file by Calc because it has many rows included so I forced to use Base instead but the problem I faced in Base is:wouldn't he be better off opening the CSV in Calc, pasting the Calc file into a BASE table