HomeActive Query BuilderTable name appear as 'Sample#txt' instead of as 'Sample.txt' when using OLE DB provider.

Table name appear as 'Sample#txt' instead of as 'Sample.txt' when using OLE DB provider.


When working with OLE DB provider connecting to CSV file, the table name contains number sign # instead of dot(.).
For example,
I have flat file with name 'Sample.txt'. In metadata it appears as 'Sample#txt'. As a result, the columns cannot be retrieved from file. What can I do with this?

My final query: SELECT * FROM Sample2#txt
Inga | email
July 31 2012, 01:55 PM
Dear Inga,

What syntax provider you use? What is the name of your OLE DB provider?
Sergey Smagin | email
24 mins since original post
This topic is closed