Re: mdb -> xls

This question is a bit like asking, "How do I turn a shopping centre into a
hospital?" Except that the structure of Access and Excel are more different
than the structure of the building you are trying to convert.

You can export tables from Access to Excel with the TransferSpread***
action/method. But that answer does not begin to deal with converting the
relational structure in Access to the flat-file structure in Excel, what to
do with the SQL queries, how to recreate the forms in Access and even
whether that is appropriate in Excel, what to do with all the reports in
Access, how to convert the Access macros which are completely different than
Excel macros, and re-writing all the VBA code as Excel VBA is very different
with different libraries and object models.

Have you even considered whether Excel is the right tool for the job for all
of these applications? Sorry: I probably should not have answered this
question as it makes no sense to me.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"pm" <pm@xxxxxxx> wrote in message news:drlgis$ofp$1@xxxxxxxxxxxxxxxxxxxxxx
> hello
>
> does anybody know how can i convert access mdb into excel xls file
> (mdb table into xls ***)
>
> is it possible at all
>
> i have almost 100 mdbs to convert
>
> best regards
>
> ps. i hope i wrote on proper newsgroup (if not, please write what
> group is best to write abou this problem)


.

Loading