Transfertext question

[Guest]

I have to export some tables for a data warehouse. At first they told me a
CSV file would be ok but now they tell me they need the output with fixed
length columns. And the lengths of the columns must not change from export to
export. Is this going to be possible? There are text columns of 255 and memo
fields involved.

 

[Ken Snell \(MVP\)]

Yes, you can export as a FixedWidth format, instead of a Delimited format.
See Help file for info about this. You'll need to create an Export
Specification that you use when you do the exports.

 

[Guest]

Well I tried this and the problem appears to be that memo fields are only
padded out to the length of the maximum size column not to the entire 64k. So
it looks like the width of these ciolumns will vary from export to export.
Or, am I missing something?

 

[John Nurick]

IIRC there's a limit to the length of the record that TransferText will
write. You may need to write VBE code to create the text file line by
line, using the VBA Print # statement.