field cut off in fixed width export file

  • Thread starter Thread starter eft
  • Start date Start date
E

eft

I need to export a query with 60 fields to a fixed width
DOS ASCII file. Doing this cuts off the data in three
fields, only the first five characters are displayed. If
I view this in the export wizard under tab delimited,
this is not the case, the complete field is reflected.
Any ideas?
 
You need to check and if necessary adjust the width of each of those 60
fields in the text export wizard.

What you see in the wizard when exporting as tab-delimited has no
bearing on what happens when you export to a fixed-width file.
 

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

Similar Threads

fixed width field for export 1
Fixed Width - No delimiters - ASCII Text File 7
Exporting Fixed Width Overlapping Fields 1
Export Text Wizard - Access 2007 1
exporting as text cutting off significant digits 2
Exporting to ascii file 4
Export Fixed With 5
Export price field in txt file without $ currency symbol 9

Back
Top