data overflow to second worksheet in workbook

J

jv

When I move data from an external source (AS400) the data will flow to a
second workbook if I have more than the 65256 record limit. If I move data
from lAccess 2003 to Excel 2003 I get a message that the transfer stopped at
the upper limit instead of going to the second worksheet. Is there a work
around for this

Thanks
Jan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data overflow to second worksheet 0
Using VBA to copy data into another worksheet ??? 2
Syncing between source worksheet and dependent worksheets 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to update data from linked worksheet back to a master worksheet? 0
2nd Pivot Table on Worksheet Crahes Excel 1
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0

Top