Re: "Too Many Rows to Output" message
- From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Jan 2006 17:23:37 +1100
IIRC, both Office Link / Analyze It with Excel and the OutputTo method
default to an earlier version of Excel format (Excel 5???) that can only
take 16K rows.
Try using the Menu File / Export ... the TransferSpread*** mothod (in VBA)
where you can specify the Excel 2000 format.
--
HTH
Van T. Dinh
MVP (Access)
"cjlars" <cjlars@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63D9D5FA-AAB3-4DE9-B6C0-048C5465A897@xxxxxxxxxxxxxxxx
>I ran a query with 42,000 records (rows) I'm trying to output to (analyze
>in)
> Microsoft Excel 2000 running Windows XP. However, I get the following
> message: "There are too many rows to output, based on the limitation
> specified by the output format or by Microsoft Access". Is there a fix
> for
> this? Can I change the limitation specified by the output format or by
> Microsoft Access?
.
- Prev by Date: Re: Date Comparison Query
- Next by Date: Re: View contents of a folder
- Previous by thread: Re: "Too Many Rows to Output" message
- Next by thread: Date Comparison Query
- Index(es):
