Cannot retrieve data from csv file using OleDbQuery
I am trying to retrieve data from CSV using OleDbQuery, but GetTable method returns empty DataTable.
Does anyone have any ideas?
Thanks,
Jun
Accepted Solution
Pegasystems Inc.
US
You haven't included enough here to say for sure. What I see is that the TableView is not connected to the output of your query. A TableView requires a TableProvider. This is set in the Properties grid and that needs to be a LookupTable. Your query outputs a DataTable but it is not assigned to anything.
To see if your query is working, extract a proxy from the query result. That should be a DataTable. Extract a proxy from the Rows property. That will be a Rows Collection which should have a Count property.
Pegasystems Inc.
JP
Thank you for your reply. A TableProvider of the TableView is oleDbQuery1 which has CommandText, "SELECT * FROM testin.csv". I am expecting a Count property of the TableView has a number of rows retrieved by oleDbQuery1, but a result returns 0. Would TableView have a count property from a result count of a TableProvider?
Please find an attachments, oleDbQuery1 and tableView1, showing property settings of the TableView and OleDbQuery.