How to use Access MDB within Excel (OleObject / VBA) 
Author Message
 How to use Access MDB within Excel (OleObject / VBA)

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



Sun, 28 Jul 2002 03:00:00 GMT  
 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.



Mon, 29 Jul 2002 03:00:00 GMT  
 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.



Mon, 29 Jul 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Open excel spreadsheet from within Access using VBA

2. Retrieving OLEObject (Image) from MDB using ADO

3. how to delete a macro within an Excel document by using VBA

4. Executing Excel-VBA code within a Access-database

5. Edit Access Record in Excel, then send back to Access using VBA

6. using VBA modules within Access

7. Using Automation objects within access VBA

8. Creating Embedded word documents from within Access using VBA

9. Using Access 2.0 VBA modules from within VB 3.0

10. Running excel add-in (added into excel - not access) in Access VBA

11. OleObjects in Access 2000 from VB6 using dataenvironment

 

 
Powered by phpBB® Forum Software