Export more than 70000

[waqas]

hai all



how we can export more than 70000 rows from access to excel.

[waqas]

hi all,

dear experts kindly tell me how can i export more than 70 thousands

rows from access to excel.

[rpeare]

The only way to do it is to break it up into multiple worksheets I think. Excel can only handle around 65000 lines per worksheet I think (I don't work with excel very much so someone can correct me if I'm wrong)

So if you're exporting more than say 60000 records you would have to export the first 60000 to one worksheet in the file followed by the remaining x many records to a second worksheet on the same file.

If you are exporting to a .csv (from your other posts I assume you are) you may have to modify your export to export to excel to get the additional worksheets

[waqas]

hi all

yes correct in excel 2003 we can not export more than 65536 rows

but in excel 2007 in one sheet more than 1 million are exist but how to export in excel 2007.

any body guide how to do it?

[rpeare]

look at docmd.transferspreadsheet

it's pretty straightforward to do with hard coded or variable items.

[boblarson]

You can do so by using my function here:
http://www.btabdevelopment.com/ts/de...aspx?PageId=48