Converting Access 97 file to Excel

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
 
J

Jeff Boyce

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

Output to Excel 2
Excel How to Fix Damaged Excel File That Won't Open? 3
Link tables 2002 to 97 1
Exporting from Access 2003 & Access 2007 to Excel 1
Converting .xls to .xlsx via DOS command 0
missing save as extensions 2
Open Excel file with command button? 8
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0

Top