read access table to create excel report

stokak

New Member
Joined
May 20, 2007
Messages
14
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. ????
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
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.
 

Forum statistics

Threads
1,181,649
Messages
5,931,216
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top