Thanks for your response. I'm not too familiar with using Microsoft
Access, so I'm not sure what you mean by "code."
Here's what I did:
I opened a *.csv file with 466,000 rows in Access. When the file was
opened in Access, I clicked on File-> Export-> to the file location to
be saved (as an Excel file). I then got the message, "You selected more
records than can be copied onto the Clipboard at one time." Then
another message popped up, "Divide the records into two or more groups,
and then copy and paste one group at a time. The maximum number of
records you can paste at one time is approximately 65,000." Another
message, "There are too any rows to output, based on the limitation
specified by the output format or by Microsft Access."
Then, I typed in record 65,000 to take me to that record and highlighted
all the records preceding it and clicked on File-> Export, as *.xls.
Next I clicked on "save formatted," and then "save selection" from the
drop down box on the right. The same message popped up: "There are too
many rows to output...."
I tried fewer rows each time, to see what the limit was. The maximum
limit seems to be somewhere between 16250 and 16500 records.
I'm not sure why it's not allowing me to copy over the 65,000 rows that
it claimed to.
I hope what I typed above makes sense. Any help would be appreciated.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!