importing access data into excel

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

How do I get information like phone numbers and addresses
from Access to get automatically imported into a
spreadsheet workbook when the user enters a name? For
example, if a user enters John Smith into the Contact
information on a spreadsheet, how can I tell the
spreadsheet to go and find John Smith in the Access
database and pull out his telephone, address, etc. and
import it into the spreadsheet?
 
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

The code is open and commented.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top