CODEWITHSUNDEEP
sqlexcelms-access
Oleg Vovk
Oleg Vovk

Reputation: 73

Export from Access to Excel limitation

I need to export 351 196 rows from Access to Excel and it allows to export not more than 65000 at a time. Is there any code which will allow to export necessary number of rows at one time?

Thank you!

Upvotes: 0

Views: 275

Answers (1)

AVG
AVG

Reputation: 1462

65K is the limit with formatting. Export without formatting.

Upvotes: 2

Related Questions