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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Output to Excel 2
Microsoft Works to Microsoft Office 6
How to Convert EML to PST in 2025? 0
Best third-party tool to repair OST files 1
Excell 2021 0
Convert MS Access'97 to MS Access 2000 4
Excel How to Fix Damaged Excel File That Won't Open? 3

Back
Top