SendObject in Access

[BobChesh]

I am trying to send a table in XL format (acFormatXLS) using the SendObject command. It works when the number of records is around 10000, but when the table is much bigger (35000), I get an error message of "too many rows". I know that Excel has a limit of some 65K, so that limit is not an issue. I know I can use TXT format, but the file size becomes 8Meg, and E mail limitations prevent this size.

Can anybody give me a reason why the XLS format cannot be used, or what the limit on rows is and why.

Regards

 

[smedvid]

MS Access may be using a driver for an older version of Excel. Seen that same problem before. My solution was to create a Text file that was comma delimited. This comma delimited file could then be named ".csv" and openned by Excel.

htwh Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[BobChesh]

Steve,

Thats what I thought.

Thanks, it works and that is all that matters.

Bob