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]

pm wrote:

hello,

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

Loop through the TableDefs collection, and use TransferSpreadsheet 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]

pi********@hotmail.com wrote:

Loop through the TableDefs collection, and use TransferSpreadsheet 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...

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]

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

...sorry, i'm beginer, and without extended explanation i do not

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" <[e-mail]> wrote in news:dr**********@nemesis.news.tpi.pl:
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)

[Br]

pm wrote:

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)

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