Macro output to excel - Too many rows!

[MarathonMan]

Using Access 2002 on XP Pro.

Query is based on 1 table and only returns the first column which is a text field 6 characters long.

If I run the query manually and copy paste into excel I have no problems.

16938 rows, excel file size 620KB

when I put the query in a macro and select Sendobject with file type of any of the 3 excel options the macro always fails when I run it. It will write to Text format ok, but I need to go to Excel.

Is there a setting somewhere that I can change which will resolve this.

""There are too many rows to output, based on the limitation specified by the output format or my msaccess"

 

[FoFa]

Sounds like a built in governor...
Try exporting to CSV format, Excel will open it like it is an excel file.

 

[MarathonMan]

Thanks FoFa,

I wasn't expecting a reply from Texas, I would love to have a go at being a cowboy for a day, let me know if you fancy an exchange for a visit to Avebury and stonhenge!

anyway I thought your suggestion was a good one, however I have version

(10.2627.6817) SP3 and my macro drop list output options are:

HTML
Text Files
Excel
Excel 5-7
Excel 97-2002
Rich Text format

So I cant even try CSV, is there a way of "switching" the CSV option on?

Kind regards

Tony

In the Valley of the Beaker Folk!

 

[FoFa]

It would be a text file.
You have options once you select that.
OR use EXPORTTEXT function, then you can select the delimition you want.