Getting data into Excel spreadsheet from an access db. (for report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to populate an excel spreadsheet with data from an Access database
(2000) table so that reports can be generated. This needs to be done on a
daily basis. I already have the excel spreadsheet setup the way it needs to
be, the user wants to now pull the data from Access instead of maintaining
both Excel and Access which is dual work.
What is the best way to do this?

I have tried in Excel to use the Data, Import external data, new database
query - but I get the following message: ODBC MS Access Driver Login Failed
- You do not have the necessary permissions to use the object.

Laurie Rodgers
 
hi,
one way would be to write your querys for your reports,
then use micorsoft query to pull the data into excel
tool>get external date>new datbase query.
You can then put a button on the excel sheet to run the
query. all your users would have to do is click a button
in excel. that is the way i do it here.
hope this helps
regards
Frank
 
Back
Top