Quick Excel Problem . . . .
07 January 2003, 03:48 PM
#1
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Little poser for any Excel gurus out there . . . .
I have 3 columns in a spreadsheet with over 142,000 values between them.
I need to sort them all as one list, but am restricted by Excels 65,536 row limit
Any idea how best to do it ?
Thanks
I have 3 columns in a spreadsheet with over 142,000 values between them.
I need to sort them all as one list, but am restricted by Excels 65,536 row limit
Any idea how best to do it ?
Thanks
07 January 2003, 04:27 PM
#7
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Yeah, thats pretty much how it was originally. But they all need merging. I'll give Access a go but don't use it so may need some pointers . . . .
Trending Topics
08 January 2003, 03:39 PM
#12
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Ar$e. Problem is, I now want to export it to a text file as one list, but it doesn't seem to do all of the records 
It keeps ending at the same point. The export doesn't end in error either ?
It keeps ending at the same point. The export doesn't end in error either ?
08 January 2003, 04:07 PM
#14
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Just did another check and I think they are all there, but in the wrong order when exported
Do I need to index or anything ? I have sorted the field in ascending order.
Any advice appreciated
Do I need to index or anything ? I have sorted the field in ascending order.
Any advice appreciated
08 January 2003, 04:25 PM
#16
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Nick, I'm still in Access.
I can sort the results on screen but when I export its not sorted.
I think I have to sort the actual table in Design View ?
I can sort the results on screen but when I export its not sorted.
I think I have to sort the actual table in Design View ?
08 January 2003, 04:36 PM
#17
Scooby Regular
Join Date: Nov 2002
Posts: 164
Likes: 0
Received 0 Likes
on
0 Posts
Oh ok sorry though you were back in excel (dohhh)
Never had that problem before exporting files
It maybe due to the amount of Data you are exporting
I have always kept large files in Access
As you can still do excel style pivots reports in Access
Never had that problem before exporting files
It maybe due to the amount of Data you are exporting
I have always kept large files in Access
As you can still do excel style pivots reports in Access
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM