Hi All,
My Access DB is around 1.9GB now, and there is only 1 big table which makes up most of the 1.9GB. We do have SQL Server at work, only issue is that the queries that run on this table are Transform ... Pivot queries and these do not work in SQL Server.
I thought perhaps I could split this table into multiple Access DBs but not sure how to link it all back together? Has anyone done this, or is there another method. The result of the queries are cut and paste into Excel, and these have already been set up to work with the data in the pivot format.
Thanks!
My Access DB is around 1.9GB now, and there is only 1 big table which makes up most of the 1.9GB. We do have SQL Server at work, only issue is that the queries that run on this table are Transform ... Pivot queries and these do not work in SQL Server.
I thought perhaps I could split this table into multiple Access DBs but not sure how to link it all back together? Has anyone done this, or is there another method. The result of the queries are cut and paste into Excel, and these have already been set up to work with the data in the pivot format.
Thanks!