Hi,
The problem might be that column names are case sensitive. So if the
column header in the CSV file is "Id", then you need to use the quoted
column name:
SELECT * FROM CSVREAD('c:/data/test.csv') WHERE "Id"<100;
I will document that. Converting column names to uppercase in CSVREAD
might be an option, but the problem is that many CSV files use spaces
in column names, so it would only be a partial solution.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
