Using Access DBs from Excel
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.
|