Problem Adding Query To Database 关注
Hi, we're having a problem connecting Bartender 8.01 to XLS or CSV data. We go through the database connection wizard and if we use standard settings, the connection looks fine - i.e. list of data can be seen in browse. When we add "SELECT * FROM `Sheet1` WHERE `REF`='?ref'" (for Excel spreadsheet) or formulate a query "file.REF = ?ref" (for CSV file) & then try to view data or print we get the query dialogue OK, but when we enter a REF that exists in the data file, we either get error message #3239 with OLE DB error 0x80040E10 IDispatch error #3088 (XLS) or 'no data' (CSV) on trying to view or print data.
We are working round by using an existing data file and adapting it with new data, but would like to know how to get this setup properly. (Technician who setup last year has now left).