Hello! I need help on linking an excel spreadsheet (with multiple sheets and tables) to MS Access 2007. The idea is that when a user opens up the excel sheet, a login userform will appear. This login userform will connect the excel spreadsheet to the ms access database. This way, whenever the user inputs new data into the fields in the excel spreadsheet (using a userform), the tables and sheets in ms access also get populated. Excel will serve as the user interface while access will collect all data being inputted into excel (note: when data sheets in excel are cleared, data sheets should NOT be cleared in the access database). I will just put the ms access file in my c: drive for example, and my excel file on the desktop.
Thank you in advance!
Thank you in advance!
Last edited: