| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extacting data from Access
Hi All
I have an Access database with around 200,000 rows, this increases by a few hundred per day. In this database is a column containing the actual date (dd/mm/yyyy). I wish to open this database from Excel, extract the following 1. The first and last date in the date base ( the Access table is not in date order) 2. A list of all dates with a count of the number of records Look forward to your responses Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Calculate data from Access and return to Access | Excel Programming | |||
| Access data -work in Excel- save in Access | Excel Programming | |||
![Nigel RS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
