Penny
If you have a well normalized Access database, you will find it difficult to
export to Excel, since Excel doesn't support a normalized structure.
Plus, if you have multiple tables (again, a well-normalized design), you
might be considering exporting each table to a separate spreadsheet?!
If you are willing to do all the work it takes to complete de-normalize
(i.e., "flatten") your data structure, probably via queries, you could
export the flattened query to Excel.
In fact, you could probably make your task easier if you created queries
that collected the data you want to export, in the format you want it
exported, and then exported the query (results), rather than the underlying
tables.
Or if you were to describe why you are trying to export your Access db to
Excel, the newsgroup readers may be able to offer alternative approaches...
Regards
Jeff Boyce
Microsoft Office/Access MVP
