Software

Ask something
Discussion Locked

Retrieving Data from Access into Excel

0 helpful
5 replies

by jmcgaughan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a problem that shows up on three computers that I know of. I have an Excel spreadsheet which gets external data from an Access database. It gets the data from one of the querries. Part of the querry uses a *wildcard in the criteria. This querry works fine in Access but returns nothing into the spreadsheet. It does work on other peoples machines. I'm using Windows 98, Access 97, and Excel 97 on all three machines. Two others that run the same spreadsheet are running Office 2000, Access 97 and one has Windows ME the other Windows 2000. They have no problem. I upgraded one computer to Office 2000, that didn't help. I then upgraded the same machine to Windows ME, that didn't help either. If I get rid of the wild card in the criteria and put in a fixed value, everything works fine. Any suggestions????

5 replies

by dklippert

Try using "%" instead of "*"
The forums indicate that "%" is the SQL equivalent of "*"
Someone suggested adding code to the SQL query such as:

select colname
from tablename
where colname like "a%"
or colname like "a*"

I'll be curious to see if it works for you.

by dklippert

Concerning using "%" and "*"; I think it may be a matter of the Jet engine version.
Take a look at this article:

Updated Version of Microsoft Jet 4.0 Available

Q239114

by jmcgaughan

The latest version of the msjet40.dll worked!!! I went to MS Knowledgebase, looked at Q239114, downloaded the update for my version of Windows, and ran it. Very simple and it fixed my problem. Thanks.

This discussion is closed to new replies.