Hi
My spreadsheet is now pushing 250k lines consisting of 20 columns of data.
Every month I have to add a new months worth of data to the sheet (approx 4k lines) and I have to refresh the last 3 months data.
So i delete the previous 3 months and then add them back in along with the new month.
This is proving tedious, Excel hangs, does not respond and crashes quite often.
I know I need to put it into some kind of access document but really not sure the best way to go about it.
Can anyone give me any advice?
Perhaps, you might tell us precisely what your spreadsheet does and what you want Access to do. Getting the data from one to the other is fairly simple. Without further information, we will have to send the request to the special mind-reading committee and they are currently backed up a least a month.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks