Exporting as Text

[Robert_Mc]

Hi all

Can anyone help with a question on exporting from Access as text? My difficulty is that whenever I export a Date/Time field, it has the date & time no matter which format I give it (general date, short date, etc); so I get, for example, 01/01/2004 00:00 when I haven't specified a time.

I'd be grateful if anyone knows a way around this.

Many thanks

 

[Mile-O]

If you are exporting a query you can use the CStr() function around the date.

 

[Robert_Mc]

Thanks for the response Mile-o-Phile. It's a shame though that any tables to be exported need to be run through a query...it seems a little unnecessary....unless anyone has any further recommendations????

 

[Mile-O]

It's a shame though that any tables to be exported need to be run through a query...it seems a little unnecessary....

It lets you select only the relevant fields you need ensuring that the final export is both quicker and smaller.