Hi,
I used to get data from external excel, access files and today tried to put together query to get data from CSV file. While using same source file, I have creted several queries to get data out based on criteria. For some strange reason, same structure queries that did run with excel or access as data source, does not want to work the same way with CSV files.
Here is example of non working query SQL:
SELECT Vendors.Vendor, Vendors.Name, Vendors.`Name 2`
FROM `Q:\Finance\Rapporter\PS\AP\Raw`\Vendors.csv Vendors
WHERE (Vendors.Name Like '%' & ? & '%')
If I enter "London" as a criteria input, it will not work. However, if I enter "ondon" it will find me all values records whre name contains London... Seems like I need to skip first symbol when entering criteria. This is, of course, not something I would like to do.
Any ideas, what mistake have I done in SQL? Strange thing is that it works perfect while in Microsoft Query application. Then I do enter "London" and it will list me all records. However, once I select "Return data to Excel" it sends me empty list... and then I need to retype criteria to "ondon" to get my list in Excel
Bookmarks