Exporting Fixed Width Overlapping Fields

N

Novice2000

Hello, I am slowly learning.

I have a query that I am trying to export as a fixed length, text formatted
*txt file. I am looking at the Export Specifications and have entered the
desired lengths of the fields as follows. The fields have to be 11, 50 , 50,
50, 50 etc.

Field A Start 1 Width 11
Field B Start 12 Width 62
Field C Start 63 Width 113

When I try to "save as" I get this message: Field 'C' overlaps with previous
field 'B'. B doesnt appear to be overlapping with A so why is C overlapping
B? What am I missing? Thanks
 
N

Novice2000

I got it. The Width is the actual character width like 11, 50, 50, 50 etc.
not a range. Thanks anyway!
 

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

Align Right certain fields of a query when exporting as fixed width txt file 2
Fixed Width - No delimiters - ASCII Text File 7
Exporting Fixed Width Text File 4
Exporting Fixed Width Text 3
Preserving trailing zeros for a fixed width file 0
Export Text Wizard - Access 2007 1
Importing Fixed Length File into Access 2007 1
Overlapping time 1

Top