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

Exporting a number field to excel from access

Status
Not open for further replies.
Buj123

Buj123

Programmer
Jan 5, 2004
96
US
Hello,
I am exporting data from table to excel sheet, and the number field is turning into date.
Ex:

In Access Table
ID Ver
55 25
65 45

Appearing In Excel sheet as
ID Ver
01/01/1900 01/04/1900
01/01/1900 01/04/1901

How to format it automatically when exporting.

 
Sort by date Sort by votes
Are you exporting to a new or existing sheet?

What are the properties of the data on the tables and queries?
 
Upvote 0 Downvote
its number in tables of access, i am exporting to new sheet
 
Upvote 0 Downvote
I think the issue here might be a default in Excel but I am really not sure. You could of course record a macro to convert everything in your excel sheet to the number format.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
830
TomSalvato
TomSalvato
PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
2K
PrimoSteve
PrimoSteve
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
486
Andrzejek
Andrzejek
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
757
hermanlaksko
hermanlaksko
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
446
Xavierparkash
Xavierparkash

Part and Inventory Search

Sponsor

Back
Top