Export Fixed With

[KADL]

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!

 

[KADL]

Forgot to mention that I am using Access 2002 SP3

 

[John Nurick]

Is there a file called Schema.ini in the folder to which you are
exporting the data?

 

[KADL]

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

 

[John Nurick]

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.

 

[KADL]

Thanks, John!

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.