ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   mdb - xls (https://www.excelbanter.com/excel-discussion-misc-queries/68225-mdb-xls.html)

pm

mdb - xls
 
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)

Kevin B

mdb - xls
 
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 Backmann


"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

best regards

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


pm

mdb - xls
 
Kevin B wrote:

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.


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

http://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


All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com