If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conversion Problem - Text to Exponential
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? |
#2
|
|||
|
|||
Conversion Problem - Text to Exponential
On Mon, 7 Dec 2009 14:50:51 -0800 (PST), Commish
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? |
Thread Tools | |
Display Modes | |
|
|