import Excel workbook into an Access Database

Question

import Excel workbook into an Access Database

amrh (Electrical)

(OP)

20 Nov 02 07:20

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 (Mechanical) · Answer 1 · 2002-11-20 08:30:07

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 www.mvps.org/access.

Patrick

Come Join Us!

Posting Guidelines

import Excel workbook into an Access Database