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!

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

Data import from Access file to Excel spreadsheet conversts to date. 2

Status
Not open for further replies.

okeyuzosike

Programmer
Joined
Jun 15, 2007
Messages
15
Location
US
Please, I need some assistance.
I am importing data from an acces table (file) into Excel spreadsheet. The data type in the access table is "Number"(numeric). When copied from the access file to the excel spreadsheet, some of the numbers converts to date.
In the source file, the underlying data is "7", but in the spreadsheet, it converts to "1/7/1900".
What is the cause of this and how can I fix it?
Note: this applies to some of the data not all. Some are numeric and some are some weired date. As you can see, the year is not even "2007" but "1900".
Thanks.
Okey.
 
Change the format of the Cell back to standard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 



This may explain SOME of the dilemma.

faq68-5827

Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top