| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to query Access DB
I already have my ADO stuff taken care of and know how to update, write and delete fields in an Access database from Excel VBA, but I cant for the life of me figure out how to get the results of a query from excel vba.. just looking to create a simple If then statement based on the record count of a particular table. Im sure this is much easier than what Im making it out to be.... Thanks!! -- durex ------------------------------------------------------------------------ durex's Profile: http://www.excelforum.com/member.php...o&userid=27857 View this thread: http://www.excelforum.com/showthread...hreadid=489259 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| VB Code or Excel macro to run Query/Import on Access file | Excel Programming | |||
| Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
| Problem with VBA code trying to query and access database | Excel Programming | |||
| Code to run an Access query from Excel | Excel Programming | |||
![durex[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
