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 derfloh 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
Joined
May 16, 2000
Messages
12
Location
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
Thanks, I didn't see that before.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top