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
|