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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't convert date for txt export

Status
Not open for further replies.
NoteSmith

NoteSmith

Technical User
May 16, 2000
12
US
I need to convert Access date fields to yyyymmdd to export to a text field. I can change the format but when I export to text, it goes back to mm/dd/yy. Any suggestions?
 
Sort by date Sort by votes
Have you set the format in the table design view to yyyymmdd? If so, are you selecting "Save formatted" before the export. I have tried this and it works. Alex Middleton
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Convert PDF to Excel spreadsheet within Access 2
Replies
10
Views
346
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
601
TheresAlwaysAWay
TheresAlwaysAWay
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
124
dhookom
dhookom
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
376
mattKnight
mattKnight
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
249
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top