By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,283 Members | 1,703 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,283 IT Pros & Developers. It's quick & easy.

Export a Table from Access 2000 to Excel - Error Msg

P: n/a
Greetings -

I am trying to export a tbl from Access 2000 that has 26,544 records.
When I export the tbl to Excel, it only exports out 16,384 records. It
also creates a tbl that shows the data export errors and it says the
following - "Rows dropped due to worksheet row limit"

I am stumped and any help will be greatly appreciated. Thx in advance.

Regards,
Sonu

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Sonu,
Apparantly you hit a wall ...
What version of Excel? What is the code you are using?
Excel 97 is *only* limited to 65.536 rows, so that should be enough ...

Arno R

"Sonu" <ma*****@aol.com> schreef in bericht news:11**********************@l41g2000cwc.googlegr oups.com...
Greetings -

I am trying to export a tbl from Access 2000 that has 26,544 records.
When I export the tbl to Excel, it only exports out 16,384 records. It
also creates a tbl that shows the data export errors and it says the
following - "Rows dropped due to worksheet row limit"

I am stumped and any help will be greatly appreciated. Thx in advance.

Regards,
Sonu

Nov 13 '05 #2

P: n/a

I have Excel 97 and 2000 on my pc....Sonu

Arno R wrote:
Sonu,
Apparantly you hit a wall ...
What version of Excel? What is the code you are using?
Excel 97 is *only* limited to 65.536 rows, so that should be enough ....
Arno R

"Sonu" <ma*****@aol.com> schreef in bericht

news:11**********************@l41g2000cwc.googlegr oups.com...
Greetings -

I am trying to export a tbl from Access 2000 that has 26,544 records. When I export the tbl to Excel, it only exports out 16,384 records. It also creates a tbl that shows the data export errors and it says the following - "Rows dropped due to worksheet row limit"

I am stumped and any help will be greatly appreciated. Thx in advance.
Regards,
Sonu


Nov 13 '05 #3

P: n/a
I have Excel 97 and 2000 on my pc....Sonu

Arno R wrote:
Sonu,
Apparantly you hit a wall ...
What version of Excel? What is the code you are using?


Sonu,
I have Excel 97 and 2000 also,
I also asked: What is the code you are using ??

If you are not using code then tell me *how* you are exporting the table.
I have Access 2000 also here. I could test if I knew what to test ...

Arno R
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.