Excel Spreadsheel linked to Access DB

[jovi07]

Hi all,

I have an excel spreadsheet that is linked to an access query.
The query returns daily revenue info (claim#, product, trade date and
commission.

This works fine but now I have to return only ethanol products. If
I put in the query criteria "Ethanol" I get only ethanol products.
Since there are more than 1 products with the name ethanol in it, I
use Like "*Ethanol*" in the criteria.

In access the query runs fine and will return all records that have
Ethanol in the product name. When I refresh the spreadsheet nothing
is returned.

Is there any reason why no records are returns while is use Like
Like "*Ethanol*"? Also is it possible to pass the date from excel to
the access query to return records for a specific date. Current i only
return records for the current date.

I am posting here but will also post this message in an excel group
since I'm not sure if I need an Access or Excel guru to solve this
problem.

Any help is greatly appreciated,

Joe V

 

[jovi07]

The query is in an access db and works if I run the query in access.

When the query has "Ethanol" in the criteria, I open the spreadsheet
and refresh it (alt +F5) to get new records that where entered today.
This works fine, but as I stated I need all products with the word
"Ethanol" in it, so I cahnge the query in Access and use in the
criteria Like "*Ethanol*". I then refresh the spreadsheet (Alt + F5).
Instead of getting all records with the word Ethanol in the product, I
get a blank spreadsheet.

This is the 1st time I ever linked a spreadsheet to an access query
but it seems Excel doesn't like it when I use Like "*Ethanol* in the
criteria of the access query.

 

[jovi07]

I made the change to use MS Query instead of Access query and its
works prefectly.

Thanks for you help