Large numbers stored as text coming up abbreviated and e+

D

dbguy5117

I have a field which is just a site code so I stored it as text, but when I
import it in to access from excel it abbreviates the number and puts e+. How
do I remove it so when i bring it back into excel I see the full number?
 
J

John W. Vinson

I have a field which is just a site code so I stored it as text, but when I
import it in to access from excel it abbreviates the number and puts e+. How
do I remove it so when i bring it back into excel I see the full number?
Click to expand...

Access has strong datatypes, but Excel does not: so when you import into
Access from Excel, the program must guess at the datatype. It does so by
looking at the first few rows to be imported; if the values of a column are
all digits, it assumes a Number datatype (erroneously, in this case).

I'd suggest having an Access table defined with appropriate datatypes (text
for this field), and *linking* to the spreadsheet, and running an Append query
to populate the Access table.
 
S

Sylvain Lafontaine

In some cases, it's simply the length of the text box who is not large
enough.
 
Top