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

Formatting problem when exporting report from Access to Excel

Status
Not open for further replies.
nimrod44

nimrod44

Programmer
Sep 17, 2001
7
0
0
US
I am using Access97 and Excel 2000. I have a report in Access with a field of Dates when a project is completed. When I run the report everything looks fine, but when I do export/Saveas to excel some of the dates randomly show as "Date Time" (ie. 3/28/2000 12:00PM). I have the spreadsheet formatted to just show the date, and not date and Time. I have found no rhyme or reason for the formatting change. The only thing I've seen is that all the times shown are 12:00PM, and I know for a fact that all these dates were not inputted at 12:00PM.
I'd appreciate any suggestiosn someone could provide.
Thanks much for the help
Darrel Seymour
nimrod44@airmail.net
 
Status
Not open for further replies.

Similar threads

OCM
  • Question
Populate access table from excel
Replies
6
Views
234
OCM
OCM
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
173
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
170
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
291
grnzbra
grnzbra
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
143
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top