Looks at importing Excel data to Access databases.
Q: Graham Alison has two Excel workbooks, and when he imports them into an Access database, he just gets the data, not the formats that make the spreadsheets work.
A: Data is all you will get when importing from Excel. If you need special formatting or calculations, you will have to redo them in Access. You may be able to use calculated fields in queries to replace replace Excel formulas. Excel macros can generally be reused, with some tinkering, since they are in VBA.
You can link Excel worksheets as tables, and bind forms to them, but it’s best to do all the formatting and calculations in Access, and just save the results to the Excel worksheet.
