Recent content by andy.russell@suncorp

Hi Bob, Yes, you'r validating where I was fearing I'd have to tread. I know how to build it in code, I was just REALLY, REALLY trying to avoid all that work just for one little issue. Never mind - thanks for your help. Maybe I can help someone else in turn. Cheers Andy

Hi Bob, Yes, that's correct. Cheers Andy

Hi, Yes, the stripping of the time component is great - but my biggest issue is still that I want the date in the text file to still look like 01-JAN-2011. It needs to remain a date type, not a string with text delimiteers (which was my other idea)

Hi George - thanks for helping with this one - but no. I'm afriad it's more complex than that - I know all about date formatting IN Access, and I have a table that holds the dates in the format I need (01-JAN-2011) But the problem occurs when I try to Export FROM Access to a txt delimited. Using...

I need to export dates in the format dd-mmm-yyyy (eg 01-JAN-2011) as part of a tab delimited txt file. I cant pass it as a string, it must not have text delimiters in the field. Using Access 2007. text file will be picked up by Oracle application. Thanks Andy