mdb -> xls

[pm]

hello,

does anybody know how can i convert access mdb into excel xls file
(mdb table into xls sheet)

is it possible at all?

i have almost 100 mdbs to convert (i'd like to do it in loop)

best regards

ps. i hope i wrote on proper newsgroup (if not, please write what
group is best to write abou this problem)

[pietlinden@hotmail.com]

Re: mdb -> xls


pm wrote:[color=blue]
> hello,
>
> does anybody know how can i convert access mdb into excel xls file
> (mdb table into xls sheet)[/color]

Loop through the TableDefs collection, and use TransferSpreads heet to
output all the tables to Excel. If I had to do this for tons of
databases, I'd do something like put them all in the same directory,
and use something like use the BrowseFolder API to specify a starting
directory and then loop through all the files in it and process each
table in each DB...

[pm]

Re: mdb -> xls

pietlinden@hotm ail.com wrote:
[color=blue]
> Loop through the TableDefs collection, and use TransferSpreads heet to
> output all the tables to Excel. If I had to do this for tons of
> databases, I'd do something like put them all in the same directory,
> and use something like use the BrowseFolder API to specify a starting
> directory and then loop through all the files in it and process each
> table in each DB...[/color]

nice, but i do not understand at all :)

sory, i'm beginer, and without extended explanation i do not mange
with that :(

do you know any example in archive or on some web?

[J]

Re: mdb -> xls

Open table in Access.
From main menu: File, Export..

Do that for each table in each db.
nice, but i do not understand at all :)
[color=blue][color=green]
>>...sorry, i'm beginer, and without extended explanation i do not[/color][/color]
manage...

You get to choose:
spend the time doing the job the long way, or spend the time learning
some VBA (Visual Basic for Applications, included with MSAccess).

:-)

J


"pm" <pm@nie.mam> wrote in news:drlh21$qbb $1@nemesis.news .tpi.pl:
[color=blue]
> hello,
>
> does anybody know how can i convert access mdb into excel xls file
> (mdb table into xls sheet)
>
> is it possible at all?
>
> i have almost 100 mdbs to convert (i'd like to do it in loop)
>
> best regards
>
> ps. i hope i wrote on proper newsgroup (if not, please write what
> group is best to write abou this problem)[/color]

[Br@dley]

Re: mdb -&gt; xls

pm wrote:[color=blue]
> hello,
>
> does anybody know how can i convert access mdb into excel xls file
> (mdb table into xls sheet)
>
> is it possible at all?
>
> i have almost 100 mdbs to convert (i'd like to do it in loop)
>
> best regards
>
> ps. i hope i wrote on proper newsgroup (if not, please write what
> group is best to write abou this problem)[/color]

Highlight the table you want, go to File/Export in the menu. change the
"Save as type" box to show "Microsoft Excel", enter the filename you want...
Done.

It's pretty standard Microsoft functionality.
--
regards,

Br@dley