Excel and Access

J

jessie2477

Hi guys, I'm trying to link my excel sheet to my ms-access db, but thi
is the following error that I'm getting:
I have some values on my excel sheet like 2215291051006
2215296060601.. and so on, and I have them formatted as Text, but whe
I go to ms-access and I click to link a table or to import the table..
those values are changed to this 2.215296060601E+12, I mean to the dat
type is changed to number instead of keeping the data type as Text...
anyone knows how can I fix this????
Thanks
Jessic
 
Top