Can You Query Specific Access Records from Excel?
 

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?

Can You Query Specific Access Records from Excel?
 

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

HTH, Greg

"neptune" wrote in message
om...
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?