import Excel workbook into an Access Database

[amrh]

Dear All,
I have a technical question for you regarding Excel workbooks and Access , do u know how to import Excel workbook (containing worksheets linked with formulas together) into a new Access Database. and how can u access the code of the workbook to know the relation between the tables and formules.
If you have a docoument for that I would really appreciate it.
Thank you a lot

--Amr

 

[plawrence]

You'll need to rebuild it. All your data will transfer but the calculations won't. I would transfer all non-calculated values to a table(s), then in a report set up calculated fields to do the same math the spreadsheet was doing. There's some good info on

http://www.mvps.org/access.

Patrick