How to add an excel worksheet capability into an Access database?

M

Mon

I wish to create an Access database which will allow me to include the
calculating features of an Excel worksheet. The reason is that the prices
used to calculate the totals vary on every situation. Those prices are for
flower wedding arrangements that vary for every wedding, therefore I can't
create a database table for them. I desire to use Access for the reporting
capability. I heard about embedding and linking, but I'm not familiar as to
which way to go or how to do it. Can someone help me?
 
K

kabaka

Go to "File -> Get External Data -> Link Tables" and select your excel
spreadsheet. Follow the wizard through and when you're done you can use the
spreadsheet as a table to base reporting on. Whenever you change the
spreadsheet & save it (in Excel) the linked table in Access will reflect
those changes.

Now, this doesn't imply that you can use a table in Access the same way you
use a spreadsheet - i.e. no Excel formulas, cell referencing etc. All the
data in the table is as if you "hard-coded" it into the spreadsheet all along.
 
J

John Vinson

I wish to create an Access database which will allow me to include the
calculating features of an Excel worksheet. The reason is that the prices
used to calculate the totals vary on every situation. Those prices are for
flower wedding arrangements that vary for every wedding, therefore I can't
create a database table for them.
Click to expand...

Sure you can. Just expand your thinking!

A table with fields for the Arrangement, the EventID and the Price
would let you add any desired number of prices, one for each different
event.

John W. Vinson[MVP]
 
Top