Hi all,
I have a large Access database that will max out the number of rows Excel can handle. I am referencing part numbers that contain over 2 million items. My users only have Excel experience so I have been tasked with attempting to maintain that standard.
Is there a way in Excel to pull Access data via a connection? I know I can import the data (too large) or try a Pivot (still too much data). Is there a magic "=getaccess" formula out there?
In my mind I see Excel serving as a dashboard. I will pull the data from Access and display nice and clean in Excel.
Thanks for the help!!!
I have a large Access database that will max out the number of rows Excel can handle. I am referencing part numbers that contain over 2 million items. My users only have Excel experience so I have been tasked with attempting to maintain that standard.
Is there a way in Excel to pull Access data via a connection? I know I can import the data (too large) or try a Pivot (still too much data). Is there a magic "=getaccess" formula out there?
In my mind I see Excel serving as a dashboard. I will pull the data from Access and display nice and clean in Excel.
Thanks for the help!!!