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

[Laurie Rodgers]

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

 

[Roger Carlson]

There are a number of ways to do this. On my website
(www.rogersaccesslibrary.com) is a small Access sample database called:
"ExportToExcel.mdb" which illustrates one way I have used.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Frank Stone]

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