cahelmster
MIS
- Jan 15, 2002
- 126
Is there any way to export a table to a text file while keeping the decimal formatting and removing the time value of 0:00:00 from date fields?
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exporting text files
- Thread starter cahelmster
- Start date
- Status
Hi
Make a query based on your table, make the date fields calulaed fields so MyDate:Format(datDate,"dd/mm/yy"
using your column names of course
and then export the query not the table
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Make a query based on your table, make the date fields calulaed fields so MyDate:Format(datDate,"dd/mm/yy"
using your column names of course
and then export the query not the table
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question