Export Query to Text without delimiters


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?
 
Ad

Advertisements

K

Ken Snell

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

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.
 
Ad

Advertisements

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top