Export Query to Text without delimiters

  • Thread starter Thread starter gumby
  • Start date Start date
G

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?
 
Concatenate all the fields into a single field, and export that single field
as a fixed-width text file.
 
I tried that already and it cut off and did not export the entire row.- Hide quoted text -

- Show quoted text -
Click to expand...

I apd to a table as a single field and then exported, work fine.
Thanks.
 
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 -
Click to expand...

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