TransferSpreadsheet to Excel limit

[Jim]

Using Access 2003 SP2 on Win XP.

I have the following command in a form

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"qry_Ambulatory_02", thePath, True

It only exports 16,384 rows. If I do an export by right clicking on the
query I get 35,508 rows.

What am I doing wrong in the TransferSpreadsheet? Is there a 16k limit?

Jim

 

[bhicks11 via AccessMonster.com]

Hi Jim,

No the row limit for Excel 2003 is 65,536. However, you may be having a
memory issue instead.

Try:

DoCmd.OutputTo acOutputQuery, "MyQuery", acSpreadsheetTypeExcel9, , True

Bonnie
http://www.dataplus-svc.com

 

[Jim]

I get the following message:

Run-time error '2306'
There are too many rows to output, based on the limitation specified by
the output format or by Statutory Reporting. (the database name).

 

[bhicks11 via AccessMonster.com]

Hmmm, what version of Excel?

Here's something that might help:

http://www.dbforums.com/microsoft-access/1629804-exporting-access-excel.html

Bonnie
http://www.dataplus-svc.com

I get the following message:

Run-time error '2306'
There are too many rows to output, based on the limitation specified by
the output format or by Statutory Reporting. (the database name).

Hi Jim,

[quoted text clipped - 21 lines]

 

[Jim]

I found a solution at http://accessblog.net/2008_10_01_archive.html If I
use

DoCmd.OutputTo acOutputQuery, "myQuery" acSpreadsheetTypeExcel9,,true

It works, if i use

DoCmd.OutputTo acOutputQuery, "myQuery" acFormatXLS,,true

it does not work. I have abandoned transferSpreadsheet.

Thanks for the help though.

Jim

Hmmm, what version of Excel?

Here's something that might help:

http://www.dbforums.com/microsoft-access/1629804-exporting-access-excel.html

Bonnie
http://www.dataplus-svc.com

I get the following message:

Run-time error '2306'
There are too many rows to output, based on the limitation specified by
the output format or by Statutory Reporting. (the database name).

Hi Jim,

[quoted text clipped - 21 lines]

Jim

 

[bhicks11 via AccessMonster.com]

Is that what I suggested above?

Bonnie
http://www.dataplus-svc.com

I found a solution at http://accessblog.net/2008_10_01_archive.html If I
use

DoCmd.OutputTo acOutputQuery, "myQuery" acSpreadsheetTypeExcel9,,true

It works, if i use

DoCmd.OutputTo acOutputQuery, "myQuery" acFormatXLS,,true

it does not work. I have abandoned transferSpreadsheet.

Thanks for the help though.

Jim

Hmmm, what version of Excel?

[quoted text clipped - 15 lines]

[quoted text clipped - 21 lines]
Jim