Conversion Problem - Text to Exponential

  • Thread starter Thread starter Commish
  • Start date Start date
C

Commish

I know that the Subject might be a little off, but here's my issue.

I am importing data from a spreadsheet into an Access database. In
this particular column of data, the data looks like this: 911B00,
91FT20, 911000, 91E000.

My issue is that when I import that column if data, for some reason it
takes the records with a "E" (like 911E00) and displays them as
exponential numbers and displays "9.10E+01" - how can I prevent Access
from doing that - or what function can a put in a query to fix that?
 
On Mon, 7 Dec 2009 14:50:51 -0800 (PST), Commish

Sometimes Access is trying a bit too hard.
I am assuming this is a Text column. You may still want to force the
issue with:
select CStr(myField) from myTable

-Tom.
Microsoft Access MVP
 
Back
Top