Export Fixed With

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a macro I am doing a TransferText Action. The Transfer Type is fixed
width, and I am using a Specification Name argument as required.

I am getting the following error: The data being exported does not match
the format described in the Schema.ini file.

FYI, The query transfers just fine as delimited.

In case this matters, I couldn't create the export specification using the
export wizard (there was no advanced button) so I used the import wizard to
create the specification. The export file is a single text 50 character
field.

Thanks for your help!
 
Is there a file called Schema.ini in the folder to which you are
exporting the data?
 
Thanks for responding, John. And no, there is not a Schema.ini file in the
folder to which I am exporting.
 
In that case I'd suspect that the query and the export specification do
not match properly. I'd try creating and saving a new export
specification.

Another approach, since there's only the one field involved, would be to
modify the existing query to return a fixed-width calculated field, e.g.

FixedField: Left([TheField] & Space(50), 50)

and export this as tab-delimited. Because there's just the one field the
result will be identical to exporting fixed-width.
 
Thanks, John!

John Nurick said:
In that case I'd suspect that the query and the export specification do
not match properly. I'd try creating and saving a new export
specification.

Another approach, since there's only the one field involved, would be to
modify the existing query to return a fixed-width calculated field, e.g.

FixedField: Left([TheField] & Space(50), 50)

and export this as tab-delimited. Because there's just the one field the
result will be identical to exporting fixed-width.

Thanks for responding, John. And no, there is not a Schema.ini file in the
folder to which I am exporting.
Click to expand...
Click to expand...
 
Back
Top