Hello,
I googled a bit about my issue here I have not found the answer to my question.
I store data monthly on MS ACCESS databases. I then have an Excel workbook that I want to use to analyze the data.
The data stored in ACCESS is recorded through Excel too btw; so Excel acts as a bridge for the data going in AND out of the ACCESS database.
So what I am trying to do is create a Connection to the ACCESS database, and then create formulas in Excel using ranges within that ACCESS database.
But I have not found out if it's actually possible or not.
I could copy the data back into Excel in the worse case scenario and use it from there, but I am pretty sure I can direct link my formulas to ACCESS directly.
I have managed to create Jet OLEDB connection to the MSA database, but I dont know what are the handles to exploit the newly made connection to MSA.
Any HowTo's would be greatly appreciated.
Thanks for helping!
Bookmarks