I am trying to display data from an external spreadsheet in a spreadshet on an ms access form. I need to be able to edit and save the data in the spreadsheet on the form. This is probably very simple but I just can't seem to get it to work. I have tried:
1. Linking a spreadsheet to an unbound frame using OLE. This seems to only display the data. The user has to click on the OLE control to open Excel and edit from there.
2. Creating a table that is linked to my source spreadsheet. This acts like a database allowing the user to add new records and edit records in a database format and will probably require a seperate form for my application.
3. Creating an ActiveX Microsoft excel spreadsheet control on my form. This is what I would like to use but I can't link it to any external data. Access only lets me enter new data and save or export that data when I am done.
Any suggestions???
1. Linking a spreadsheet to an unbound frame using OLE. This seems to only display the data. The user has to click on the OLE control to open Excel and edit from there.
2. Creating a table that is linked to my source spreadsheet. This acts like a database allowing the user to add new records and edit records in a database format and will probably require a seperate form for my application.
3. Creating an ActiveX Microsoft excel spreadsheet control on my form. This is what I would like to use but I can't link it to any external data. Access only lets me enter new data and save or export that data when I am done.
Any suggestions???
