MDB add-ins for Excel 97

[Pieter]

Does anyone know how I can open .MDB files in Excel 97 if
I don't have access installed? Are there add-ins or plug-
ins available which would enable me to do this?

 

[Tom Ogilvy]

You can do Data=>Get=>External Data and select access as your data source.
(create a new query). The Jet database engine enables access to the .MDB
files without having access installed.

You can use the same approach programmatically (add a querytable or a
pivottable).

Or you can access them using ADO or DAO

http://www.erlandsendata.no/english/index.php?t=envbadac
sample code a Mr. Erlandsen's site.

 

[Guest]

Thanks Tom for your help!
It hasn't quiet worked yet but that might have something
to do with the fact that the MDB is created by a visual
basic program.
regards,
Pieter
(in Brussels)

 

[Peter Atherton]

-----Original Message-----
Does anyone know how I can open .MDB files in Excel 97 if
I don't have access installed? Are there add-ins or plug-
ins available which would enable me to do this?
.

Pieter

Export the original file in Access as an Excel File or as
a text file and you can cutand paste itinto Excel.

Peter

 

[Tom Ogilvy]

I don't have access installed?


What method would you use to do that if Access isn't installed?