read access table to create excel report

[stokak]

i need to write vb code to open an access table and extract all columns but just the rows in specific date ranges indicated by the user. ????

 

[Derek Brown]

I see that although a number of people have viewed your Post, you have not yet received any help.
Looking at your message, it seems that there is insufficient information to enable an easy answer to be given.
There are a number of ways to approach this ....use Microsoft Query to import all records and then extract the required data in Excel ....... create the Query using SQL in VBA ...... using ADO/DAO to read the table ....... and so on.

O'Reilly publish a good book that you may find helpful:- Integrating Excel and Access ISBN 0-596-00973-9 $39.95 USD (probably cheaper on Amazon). You can buy the PDF version, or just selected Chapters, online at:
[url]http://www.oreilly.com/catalog/integratingea/index.html
[/url]
My copy is the first edition (October 2005) and has 216 pages. In my copy, Chapter 3 is titled "Data Access from Excel VBA" and consists of 20 pages.
Of course, it does assume that you are comfortable with writing Excel VBA.
Hope this helps.