Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Are you trying to query the database or do something else? If the first case: You can pull up data directly from Excel using the External Data featu menu Data Get (or Import) External Data New Database Query. There choose MS Access and follow the dialogs. In vba, it is similar to buikding a QueryTable object. (do the step above with the macro recorder On, then check at the automated code). I hope this helps, Regards, Sébastien "Mister T" wrote: In an Excel routine, I access an Access database with a GetObject. But before I do that, is there a way to find out if an instance of that particular DB has already been launched? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
access--excel--access | Excel Programming | |||
How to access ACCESS from Excel! | Excel Programming |