Can You Query Specific Access Records from Excel?

  • Thread starter Thread starter neptune
  • Start date Start date
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?
 
Excel allows use of MSQuery. Look under the Data menu/Get External Data/New
Database Query. You can build macros also.

HTH, Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access query(with custom function) from Excel 3
Running an Access function (with parameters) from Excel 6
Link, drop link, relink 2
Query from Excel to Access - Passing Parameters? 8
Copying jpeg image data date into excel 0
Excel-Query-Access Question 3
Best way to get data from Access 2003 to Excel 2003 6
Custom Document Properties in Word documents and Excel workbooks 13

Back
Top