Maximum fields on Query Export?? Anyway round this? 1

[Moss100]

I am running a query that has quiet a large number of fields, i think about 40.

The query runs fine, but access will not allow this number of fields to be exported.

Any ideas?

Many thanks

Mark

 

[lupins46]

What format are you exporting to?

 

[Moss100]

Just exporting as a text file. But when i have too many fields Access greys out the 'export' option.

 

[MichaelRed]

" ... when i have too many fields Access greys out ... "[/qoute] ... Really? at just 40 fields? really? Somthing fishy this way smells. If the query can be run IN access, exporting it shound N O T be restricted because of the field count.

Ms. A. (and many relational dbs) have limits on the nyumber of fields in a recordset. They also have varying, various and arcane definitions of the "field count", which includes elements like indicies, aggregate clauses and other conditionals, so their count seldon equals the number of columns you can count in the display. BUT, if the field count exceeds the limitm hte query doesn;t run as a query either, so the export is not really an issue.




MichaelRed