Can You Query Specific Access Records from Excel?

N

neptune

I have an Access database with thousands of customers. In excel I
have 300 customer#s. I want to match the customer# with address,
phone, etc. The only way I know is to import the file into
Access, build a query and export it back to Excel. Is there an easy or
quicker way to do this from Excel, given that this needs to be done
frequently?
 
G

Greg Koppel

Excel allows use of MSQuery. Look under the Data menu/Get External Data/New
Database Query. You can build macros also.

HTH, Greg
 
Top