nagovind
Member
Dear All
I have a program in which i have generated 65560 numbers to construct a Chart (X-Y scatter) fine
My aim is to reduce the file size of the Excel file
So i will use the MS-Access as the back end to store the data if and then required i will take the data from the MS-Access and place it in the excel fine
I'm using array function to generate the series point. (THANKS to HUI)
If anybody provides a code to write the MS-Excel VBA generated array to MS-Access data base and bring back the same data whenever required.....it will be of great help to me please
I have a program in which i have generated 65560 numbers to construct a Chart (X-Y scatter) fine
My aim is to reduce the file size of the Excel file
So i will use the MS-Access as the back end to store the data if and then required i will take the data from the MS-Access and place it in the excel fine
I'm using array function to generate the series point. (THANKS to HUI)
If anybody provides a code to write the MS-Excel VBA generated array to MS-Access data base and bring back the same data whenever required.....it will be of great help to me please