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?

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/...php?t=envbadac
sample code a Mr. Erlandsen's site.

--
Regards,
Tom Ogilvy

"Pieter" wrote in 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?

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)
-----Original Message-----
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/...php?t=envbadac
sample code a Mr. Erlandsen's site.

--
Regards,
Tom Ogilvy

"Pieter" wrote in
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?


.

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

I don't have access installed?


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

--
Regards,
Tom Ogilvy

"Peter Atherton" wrote in message
...

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