Linking Excel to Access
I have created multiple Excel worksheets that currently function as automated
forms; they contain drop down menus, calculations, and multiple validations
to reduce user error. At this point the forms are printed; but what I am
hoping I can do is feed the entered data into an Access database.
Does anyone have any suggestions as to where I start in figuring out how to
do this? There are multiple users so that is also a consideration, ideally I
would like it to feed one database, but if for the initial set up I had to
feel individual ones and then link the data together, that would be okay as
well.
Thank you in advance for your assistance.
--
AB
|