(Complete Access noob here)
Hi guys!
I inherited a task where I have 15 CSV files that are about 4 million records large. When I combine them into smaller number of files using Access, I understand that I cannot have more than 2 GB worth of data in a single database. So I have been creating three separate Access Databases and linking them to an Excel file pivot table.
Now the question is whether I can have the three separate Access databases feed into a single pivot table, as opposed to having three separate pivots? The Access files in question have the exact same # of columns & its headers. The only difference is the content of the files.
Thanks in advance!
Bookmarks