D
Dennis
I must export 130+ data tables to Excel...and those data tables are in an
(one single) Access database as separate, unrelated tables. The Access
database appears to be an Access 2000 creation.
Trust me....there are NO relationships. It is as if someone created
speradsheets within Access. Although the tables contain similar content,
they represent distinct groups of records.
I can open each table and export it as an Excel file (with types and content
sufficient for my further processing requirements). However, this is a
recurring task for which I have recently been given responsibility.
I am not very experienced in Access (I have created and used simple
databases in the past; yes, relational)--but there has to be a better/faster
way to do this export operation. I would be happy to export all tables as
separate tabs or worksheets in one Excel workbook, if that can be done
instead.
Help!
(one single) Access database as separate, unrelated tables. The Access
database appears to be an Access 2000 creation.
Trust me....there are NO relationships. It is as if someone created
speradsheets within Access. Although the tables contain similar content,
they represent distinct groups of records.
I can open each table and export it as an Excel file (with types and content
sufficient for my further processing requirements). However, this is a
recurring task for which I have recently been given responsibility.
I am not very experienced in Access (I have created and used simple
databases in the past; yes, relational)--but there has to be a better/faster
way to do this export operation. I would be happy to export all tables as
separate tabs or worksheets in one Excel workbook, if that can be done
instead.
Help!