Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very large database (600k rows, 40 columns in xlsx)
Hello!
Im using Excel 2007 file to store very large database: 600k rows & 40 columns in one spreadsheet. Its more than 250MB on hard drive. Im using it to draw many charts. Usually I copy charts to PowerPoint 2007 to get small file sieze. I wonder if its possigle to transfer data from xlsx to another file, and use it as external data source. My target is to get small xlxs files, without any need to copy charts to PowerPoint 2007. I was trying to put data into Access 2007 db, but.... System was crashing during importing. What is most efficient method of storing such a big database, to use it in Excel 2007 ? I hope that someone answer my question. Its first time I write on this newsgroup... :) regards, Przemek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
large database with multiple rows | Excel Worksheet Functions | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
Converting rows to columns on a large scale | Excel Discussion (Misc queries) | |||
Converting rows to columns on a large scale | Excel Discussion (Misc queries) |