sendobject too many rows

[Peter]

I am using following command to email a table as a file
attachment.

DoCmd.SendObject acSendTable, strTableName, acFormatXLS,
strEmail_Addr, , , "file from Central", , False

Suddenly I am getting following error

There are too many rows to output, based on the limitation
specified by the output format or by Square One Pc Central.

(Square One Pc Central is my access front end)

When I make the table smaller, works fine.

I've tried to find some documentation on this with no luck.

Any suggestions would be appreciated!

From: Old COBOL programmer, new Access guy

 

[John Nurick]

Hi Peter,

At a guess - I've never used SendObject myself - it uses the old Excel
5.0/95 file format which can't hold more than 16384 rows. This is
certainly true of DoCmd.OutputTo.

The newer DoCmd.TransferSpreadsheet command allows you to specify more
recent Excel formats which accommodate up to 65536 rows; but you'd have
to write code to send the resulting file as an attachment. IIRC there
are examples of how to do this at http://www.mvps.org and/or
http://www.granite.ab.ca/access/email.htm .

I am using following command to email a table as a file
attachment.

DoCmd.SendObject acSendTable, strTableName, acFormatXLS,
strEmail_Addr, , , "file from Central", , False

Suddenly I am getting following error

There are too many rows to output, based on the limitation
specified by the output format or by Square One Pc Central.

(Square One Pc Central is my access front end)

When I make the table smaller, works fine.

I've tried to find some documentation on this with no luck.

Any suggestions would be appreciated!

From: Old COBOL programmer, new Access guy

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Pete]

John. Many thanks for your ideas on the problem. Pete.

-----Original Message-----
Hi Peter,

At a guess - I've never used SendObject myself - it uses the old Excel
5.0/95 file format which can't hold more than 16384 rows. This is
certainly true of DoCmd.OutputTo.

The newer DoCmd.TransferSpreadsheet command allows you to specify more
recent Excel formats which accommodate up to 65536 rows; but you'd have
to write code to send the resulting file as an attachment. IIRC there
are examples of how to do this at http://www.mvps.org and/or
http://www.granite.ab.ca/access/email.htm .

I am using following command to email a table as a file
attachment.

DoCmd.SendObject acSendTable, strTableName, acFormatXLS,
strEmail_Addr, , , "file from Central", , False

Suddenly I am getting following error

There are too many rows to output, based on the limitation
specified by the output format or by Square One Pc Central.

(Square One Pc Central is my access front end)

When I make the table smaller, works fine.

I've tried to find some documentation on this with no luck.

Any suggestions would be appreciated!

From: Old COBOL programmer, new Access guy

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.