Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO read of Access...
I am using the routines the Ron de Bruin has on his website to do an ADO read
of an Access database and return the results to Excel. This is working great for all the queries I have done, up until now. I need a new query, but the selction criteria for the record has to match only part of the field contents, e.g. I want to search for "TST", but the fields contain "TST Network", "TST DBA Mainframe". Basically, I need to return all the records that contain "TST" at the beginning of the field. Thank's in advance for any help... -- Cheers... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO read of Access...
SELECT Table1.*, IIf(Left([Field2],3)="TST","Yes","No") AS leftValue
FROM Table1 WHERE (((IIf(Left([Field2],3)="TST","Yes","No"))="Yes")); "Deke" wrote: I am using the routines the Ron de Bruin has on his website to do an ADO read of an Access database and return the results to Excel. This is working great for all the queries I have done, up until now. I need a new query, but the selction criteria for the record has to match only part of the field contents, e.g. I want to search for "TST", but the fields contain "TST Network", "TST DBA Mainframe". Basically, I need to return all the records that contain "TST" at the beginning of the field. Thank's in advance for any help... -- Cheers... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO read of Access...
Use the SQL "like" operator
Tim "Deke" wrote in message ... I am using the routines the Ron de Bruin has on his website to do an ADO read of an Access database and return the results to Excel. This is working great for all the queries I have done, up until now. I need a new query, but the selction criteria for the record has to match only part of the field contents, e.g. I want to search for "TST", but the fields contain "TST Network", "TST DBA Mainframe". Basically, I need to return all the records that contain "TST" at the beginning of the field. Thank's in advance for any help... -- Cheers... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access the read-only box on my disc? | Excel Discussion (Misc queries) | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
read access db using excel vb | Excel Programming | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
read Access table from VBA | Excel Programming |