Export Query to Text without delimiters

[gumby]

I need to export a query without delimiters. I have setup the query to
have eash field right padded and need to export to a text file so that
the each row is exactly 857 char. I have tried several times with the
wizard. Any ideas? VBA?

 

[Ken Snell]

Concatenate all the fields into a single field, and export that single field
as a fixed-width text file.

 

[gumby]

Concatenate all the fields into a single field, and export that single field
as a fixed-width text file.
--

        Ken Snellhttp://www.accessmvp.com/KDSnell/






- Show quoted text -

I tried that already and it cut off and did not export the entire row.

 

[gumby]

I tried that already and it cut off and did not export the entire row.- Hide quoted text -

- Show quoted text -

I apd to a table as a single field and then exported, work fine.
Thanks.

 

[Ken Snell]

Use an Export Specification to tell ACCESS how many characters are in the
"single" field. If you don't provide a specification, ACCESS uses a default
length (255 characters, I think?).

--

Ken Snell
http://www.accessmvp.com/KDSnell/

Concatenate all the fields into a single field, and export that single
field
as a fixed-width text file.
--

Ken Snellhttp://www.accessmvp.com/KDSnell/






- Show quoted text -

I tried that already and it cut off and did not export the entire row.