Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 05, 04:46 PM
Roland
 
Posts: n/a
Default maximum number of rows that can be coppied to clipboard

is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,

  #2   Report Post  
Old April 27th 05, 05:05 PM
gls858
 
Posts: n/a
Default

Roland wrote:
is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,

I have Access 2003 when I tried to copy a table with 70,000 records
it said the limit was about 65,000.

gls858
  #3   Report Post  
Old April 27th 05, 05:09 PM
Andy Wiggins
 
Posts: n/a
Default

65536

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Roland" wrote in message
...
is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,



  #4   Report Post  
Old April 27th 05, 05:10 PM
Andy Wiggins
 
Posts: n/a
Default

65536 if you want to paste them into Excel.

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Roland" wrote in message
...
is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,



  #5   Report Post  
Old April 27th 05, 05:51 PM
zackb
 
Posts: n/a
Default

What are you doing with it? Pasting to Excel? As Andy states, you must
remember, Excel is currently limited to 65,536 rows and 256 columns.

--
Regards,
Zack Barresse, aka firefytr


"Roland" wrote in message
...
is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum number of rows? Allan Bach Excel Discussion (Misc queries) 5 April 14th 05 12:37 PM
Is there a maximum number of non-contiguous columns that can be h. Harold Excel Discussion (Misc queries) 6 March 1st 05 09:10 PM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM
Dynamic number of ROWS Gerrym Excel Worksheet Functions 2 November 16th 04 04:03 PM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017