MDB add-ins for Excel 97

P

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?
 
T

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.
 
G

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)
 
P

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?
.
Click to expand...
Pieter

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

Peter
 
T

Tom Ogilvy

I don't have access installed?


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