CAN I READ DATA DIRECTLY FROM ACCESS TO EXCEL???

  • Thread starter Thread starter benton via AccessMonster.com
  • Start date Start date
B

benton via AccessMonster.com

Is there a way I can read data directly from an access query to excel
without having to import it to excel???
 
I assume you mean how do you query an Access Database without importing
all the tables in and having an Excel spreadsheet full of raw data
which you then have to manipulate in Excel?

In Excel... Data, Import External Data, New Database Query, New Data
Source, <name>, Microsoft Access Driver, Connect... set up your query
using MS Query.

You can do a parameter query in Excel by putting square brackets around
"value" in the value field in the criteria pane, then on the way out
click "parameters" and select the cell which you want to be your
criteria.

Hope this helps.

Travis
 
Back
Top