ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking Excel to Access (https://www.excelbanter.com/excel-discussion-misc-queries/121440-linking-excel-access.html)

AB

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


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com