Converting Access 97 file to Excel

  • Thread starter Thread starter larryv8
  • Start date Start date
L

larryv8

I would like to convert an Access 97 file on an XP PC to an Office Excel 2007
file on a Vista PC. Is this possible, is so, how is it done?

Thanks
 
First, an Access .mdb file (a "database") is NOT a big spreadsheet. Often
an Access application contains data, screens (forms), queries, reports,
code, macros, ... Only the data portion is transferable to a spreadsheet.

But wait, there's more! A well-normalized Access database is relational.
Spreadsheets are typically "flat". Are you looking to export each/every
table to a separate spreadsheet, or are you planning to "flatten" a
relational database for consumption via Excel?

More info, please!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top