I have an Excel 2007 sheet that has several data tables, Access is the source. Some tables are large, others small. My goal is to have the users modify the data in the tables and then save it back to Access.
I know I can loop through a range and execute one append/update transaction per line, but I would really like to Excel append all the records at once into a blank staging table in Access. Is there anyway to make a recordset out of a range on a worksheet? If so, can I pass that recordset to Access?
Thank you to all that take the time to read this.
sabloomer
I know I can loop through a range and execute one append/update transaction per line, but I would really like to Excel append all the records at once into a blank staging table in Access. Is there anyway to make a recordset out of a range on a worksheet? If so, can I pass that recordset to Access?
Thank you to all that take the time to read this.
sabloomer