software

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

best regards

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

In Access, select the table or query you wish to export and click on File,
select Export, change the Save as type to the Excel flavor of your choice and
click the Save All command button.
--
Kevin Backmannquot;pmquot; wrote:

gt; hello,
gt;
gt; does anybody know how can i convert access mdb into excel xls file
gt; (mdb table into xls sheet)
gt;
gt; is it possible at all?
gt;
gt; i have almost 100 mdbs to convert
gt;
gt; best regards
gt;
gt; ps. i hope i wrote on proper newsgroup (if not, please write what
gt; group is best to write abou this problem)
gt;

Kevin B wrote:

gt; In Access, select the table or query you wish to export and click on File,
gt; select Export, change the Save as type to the Excel flavor of your choice and
gt; click the Save All command button.

or import data to excel, but as i wrote before

i have almost 100 mbd files, and they are files that
are protect before table view, i can anly see data in form

but there is no protection against importing, but i
cannot export.

example of such mdb is he

miodek.np-ip.org/~zdj/example.mdb

and i ask about some tool, macro in xls which can convert
all mdbs into xls (table into sheet)

rgs