I have a workbook that processes many rows of data and extracts a list of summary parameters which is contained on the last sheet of my workbook. My workbook needs to be able to push the data that is extracted on the last sheet to an Access database table. I am running into trouble in that Excel can only handle just over one million rows, and my list will eventually be larger than that. So I need my last sheet to push its data to Access, then be able to clear out my workbook for a new set of data to be inputted extracted, then add the extracted data to the existing list in Access, and repeat again. So my database will grow each time I run an extraction.
Bookmarks