Fetch Access data from Excel
 

Good morning -

Tried to 'search' for help on this, but I don't think I'm using the
correct terminology....

I've built an Access database which uses 4 queries to get to the
desired data set. I've also designed an Excel workbook that takes the
result set and slices/dices it several ways -- the initital design of
this used a manual export from Access. This is where I get stuck....

My goal is to have the Excel file do all of 'the work'. When a user
opens the file, the see the 'old' data and then by pushing a button,
they're able to see the most recent data. Ideally, pushing this button
would trigger the Access database to completely update itself (ie run
all 4 sections).

How do I do this? Right now, my 'final' results in Access sit in Query
#4 -- I could easily do a 'make-table' and link Excel to this created
table. Would that be any better?

Any help at all is greatly appreciated!

Rgds, Ray

Fetch Access data from Excel
 

Personally, I like to pull my data from Access using an ADO connection.

You can find an example of this at my site: http://www.excelguru.ca/node/23

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

wrote:
Good morning -

Tried to 'search' for help on this, but I don't think I'm using the
correct terminology....

I've built an Access database which uses 4 queries to get to the
desired data set. I've also designed an Excel workbook that takes the
result set and slices/dices it several ways -- the initital design of
this used a manual export from Access. This is where I get stuck....

My goal is to have the Excel file do all of 'the work'. When a user
opens the file, the see the 'old' data and then by pushing a button,
they're able to see the most recent data. Ideally, pushing this button
would trigger the Access database to completely update itself (ie run
all 4 sections).

How do I do this? Right now, my 'final' results in Access sit in Query
#4 -- I could easily do a 'make-table' and link Excel to this created
table. Would that be any better?

Any help at all is greatly appreciated!

Rgds, Ray