Exporting Access 97 Query to Excel 97 - 16,384 row limitation



I am exporting a local Access table with > 16,384 rows but
only 16,384 rows actually get exported. I know that
earlier versions of Excel have a 16,384 row maximum but
Access 97 introduced a 65,536 row maximum. I can manually
export the rows from access and it will then allow me to
export >16,384 rows, however, I need to automate this for
our users. Originally I was exporting via a macro and now
I'm trying via VBA code using Transferspreadsheet but the
16,385 row limitation still seems to come into play this
way as well. Any other ideas?


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