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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Output to Excel converting string values to datetime 1

Status
Not open for further replies.
AGOSWAMI

AGOSWAMI

Programmer
Feb 24, 2003
4
US
While exporting Reports from MS-Access to Excel, string values such as 11-0001 is getting interpreted as dates and in the ultimate Excel output, this comes up as a number ( number of days from 01-01-1900, I guess). Any help?
 
Sort by date Sort by votes
I forgot to mention one thing. This works fine in Access 97. It is only a problem with Access 2000.
 
Upvote 0 Downvote
Great!!! The Service Pack fixed it. However, I was just playing around with different versions of Access and found that the problem is still there for Office XP. I could not find any Hot fix / service pack for this issue on XP. Is there something out there or perhaps a workaround?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
582
dhookom
dhookom
iamchemist
  • Locked
  • Question
Push To WORD?
Replies
3
Views
501
iamchemist
iamchemist
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
254
GPnew
GPnew
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
3K
EwaFAMA
EwaFAMA
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
412
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top