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?
|