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 strongm 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
Jun 15, 2007
15
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top