Date & Time Fixed Width Export

[yellow]

I have a TEXT field in a table which stores todays date. 30-OCT-2002. It is 11 characters in width.

Please can someone tell me why when I export it as a fixed width file does Access try to add the time, produce an Export Errors table saying the field has been truncated AND change my TEXT field to a it's own format of 30-10-2002.

I have tried storing this field as a date data type, I have tried exporting a query of the table and formating my field in there but it still changes it.

It is a text field, why does it intefere and change it to a date and try to add the time. When it realises the output spec doesn't have enough room for "it's" time it dumps the error in a table.

If I create a new table with a text field, type my date in there, export that field to a fixed width file, it doesn't alter my format???

WHYYYYYYYYYYYYYYYYYYYYYYYYY?

 

[ritchieroo]

Roll your own Fixed-Width export

With a little bit of coding you can break your reliance on Access's inbuilt functionality and regain full control over your exports.

See example code attached

 

[yellow]

Thankyou for your reply. I was trying to avoid doing what you have suggested. I really wanted to know why Access decides to ignore what I have told it to do and do it's own thing.