
How to use Access MDB within Excel (OleObject / VBA)
I doubt you'd be able to embed an Mdb file into an Excel spreadsheet.
What you might have to do is Reference the Microsoft Access Object
Library to get to your data in VBA or use MS Query.
----
Quote:
> Hello there!
> I'm trying to use an embedded MS Access MDB within Excel.
> Through Excel VBA, I can get to the OleObject container, but not
> to the MS Access MDB object.
> Due to our requirements, the MDB really need to be embedded within the
> excel spreadsheet.
> I'm trying to get programmatically to the MDB data, and queries in
fact.
> Is it possible? How?
> Thank you for your help.
> Jean-Marc Duchi
> Caterpillar S.A.R.L.
> Geneva
--
++++++++++++++++++++++++++++++++++++++++
Check it:
O.o. H.N.N. o.O.: http://hackernews.com
Sent via Deja.com http://www.deja.com/
Before you buy.