HomeActive Query BuilderTo retrieve data from CSV file

To retrieve data from CSV file


I cannot retrieve data from flat .txt file (csv format) using ODBC or OLEDB connection. It gives me error on table name prefix to the field name in the SQL query. Once I remove table prefix in SQL query, all work fine. Is there any option to avoid a table name as a prefix?
Inga | email
June 18 2012, 12:08 PM
Dear Inga,

currently Active Query Builder always adds a table prefix for all fields used in a query to remove ambiguities.
We have plans to create a property to skip such prefixes if there are no ambiguities, but currently it is not implemented.

But I can advice to use simple aliases for tables used in your query, this workaround can help to avoid the underlying driver error.
Vitaly Sotnikov | email
1 day, 11 hours since original post
This topic is closed