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
<(E-Mail Removed)> wrote:

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


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