65,000 records

[kwooten]

Is there any way to overwrite the 65,000 record limit?

[ssanfu]

Is there any way to overwrite the 65,000 record limit?

There is not a 65,000 record limit. Access can hold millions of records. I'm not sure why you think there is a limit. Access has a file size limit of 2 gigabytes.

See:
http://office.microsoft.com/en-us/ac...010030739.aspx

[kwooten]

Maybe I should have been a bit clearer

"You selected more records than can be copied onto the Clipboard at one time.

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."

I ran a DB and tried to export it to excel.

[ssanfu]

Maybe I should have been a bit clearer

"You selected more records than can be copied onto the Clipboard at one time.

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."

I ran a DB and tried to export it to excel.

I haven't run into a clipboard limit, but Excel 2000-2003 worksheets do have a 65,536 row limit.
Excel 2007/2010 row limits are 1,048,576 rows.

[kwooten]

I knew that.. I am running Office 07. Ill figure it out

[TheBrigg]

I know this thread is a little old, but incase the issue is unsolved or someone stumbles upon it in the future like I did, here is some additional info.

There is not a way to increase the limit. The only feasible method, aside from using something separate from Excel (highly advised), is to draw only 65000 records at a time and then copy/paste them. This is similar to what is called Pagination. After pulling records 1 to 65000, you would then pull records 65001 to 130000. It is a pain, but the only work-around that I'm familiar with.

[kwooten]

I figured out that if, when selecting to export to excel, you dont check any of the 3 boxes then the export will run all records.

[Cryptic]

More specifically, in the export wizard, leave the "Export data with formatting and layout" unchecked and it will export!

MS KB article: http://support.microsoft.com/kb/924681