how do I link access to excel cells ?

[Michele]

I would like to be able to use my GUI i have created in Excel and store the data input to an access database....is this possible and how would I ?
Sorry, I have never used access but have a little (little) knowledge with Excel...

if this helps, here is the cell range I need to put into the data base:
b2:d4....

thanx in advance for any and all help....

M

 

[Ziggy]

The answer is yes depending on the structure of your spreadsheet. if your spreadsheet is organized as a proper datalist(each row is a record), then the spreadsheet can be linked to an access database (or imported). Since you've never used access, it is difficult to instruct you fully on how to make it all work.


If you link to Excel the changes are dynamic, changes in Excel will update in Access and vice/versa. But the data will remain stored in Excel (unless you update it to another table in Access).

If you import the excel data it will exist in an Access table.


Your going to have to read up on Access because there are going to be many things to take into account, depending on how you want to manage your data.

Ziggy