Exporting as an Unformatted Test File

[Wendy C.]

I am trying to export the results of a query as a text file without
formatting. The Export with formatting button is checked and greyed out, adn
I can not de-select it. Is there some sort of option that I need to set so
that this button is available?

 

[Clifford Bass]

Hi Wendy,

What version of Access? Is this true of all queries or only one? Is
there some kind of unusual content in the query results other than text and
numbers? You could try removing any non-alphanumeric type fields to see if
that makes a difference.

Clifford Bass

 

[Wendy C.]

Hi Clifford,

I am using Access 2007, but it also happens in Access 2003. I have 3 fields
that I am trying to export - 2 text adn 1 numeric.

 

[Clifford Bass]

Hi Wendy,

This is pretty odd. That it happens in both 2007 and 2003 kind of
eliminates some kind of version-specific issue. You did not answer; is it
only that query? If not, is it all queries in that database? All queries in
any database? You could try a compact and repair. Or, try importing the
appropriate tables and query into a new database; see if it works from there.

Clifford Bass

 

[Pete D.]

What type exported file are you trying to use. Txt, CSV... etc