Topic: Creation to the pivot table in Excel from basis Access
Good afternoon! It is required to create the pivot table in from the several tables an ex-fur-tree allocated in different files. For this purpose I connect these tables with , then through sql request I unite them. Further I open an ex-fur-tree and I connect to it the data from request and I create the pivot table. Thus I unite the data from several tables an ex-fur-tree and I provide possibility of their update at change of the initial table.
However, at attempt to connect the data from request the error that there is no storage takes off. In the manager of tasks the ex-fur-tree during this moment consumes 1,7 operative storage. the request connects eight bases, each of which weighs about 130 Mb.
Whether I do all correctly? Whether there is a possibility somehow to avoid shortage of storage? Can eat other methods to unite labels an ex-fur-tree in a uniform report, thus saving possibility of its fast update?