Specify Column length in text file

[balistikb]

I am using a DTS to export from an Access table to a text file. How can I specify the length of each field once it is in the text file?
HELP

 

[JayKusch]

Why would you need the length of each field? If you export the data in a comma or tab delimited format, it does not matter, more or less, the size of the fields. SQL Server can import the file based on the format choosen.

Thanks

J. Kusch

 

[balistikb]

Actually I am exporting to a text file and that text file is being used for another application that needs specific column width when importing that information.

 

[JayKusch]

You then may want to post that question in the DTS or more the Access forum since this forum stricyly deals w/ SQL Server Programming. Good Luck!

Thanks

J. Kusch

 

[AtomicWedgie]

SELECT '"' + SPACE(20-LEN('this')) + 'this' + '"'
, '"' + SPACE(20-LEN('is')) + 'is' + '"'
, '"' + SPACE(50-LEN('a')) + 'a' + '"'
, '"' + SPACE(50-LEN('test')) + 'test' + '"'

This is just an example. I am not sure if this is the best way but it works for me. Just replace the text with the fields you want in the query.

You don't need the '"' in the query, they are just to make the result of this example more visible

Atomic Wedgie

 

[AtomicWedgie]

Hmmm,

I am not sure if the query will also work within access.

Atomic Wedgie