Large numbers stored as text coming up abbreviated and e+

[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?

 

[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?

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.

 

[Golfinray]

Go into design view of the table and change the field size.

 

[Sylvain Lafontaine]

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