| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Importing Access Query into Excel using ADO
Fieldnames are not necessarily 'column' names! The fieldname might very well be
"CurrentYear" or simply just "Year" in your WHERE clause. Hard to say without examining how the data table is constructed in the mdb file. Open it in Access and study its structure to see how the fields are defined... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data from Access Query to Excel Sheet | Excel Programming | |||
| Importing Access Query in Excel 2007 | Excel Programming | |||
| Importing access query | Excel Discussion (Misc queries) | |||
| Importing Access Query | Excel Discussion (Misc queries) | |||
| Importing Complicated Access Query into Excel | Excel Programming | |||
![GS[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
