Does anyone know why numbers in a column in Excel change when imported to an Access2K table? Ex.I have numbers 1.10,1.30,etc but when I import them into Access it changes the data to 1.1 and 1.3 respectively. I've tried the advance import menu, changing table properties,damn near everything but same result.Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help importing an Excel worksheet into Access 1
- Thread starter Oz1127
- Start date
-
1
- #2
I would guess that importing does not bring in any formatting info; so just as you had to format the number in Excel to get the trailing zero you will have to do the same in Access by setting the format to fixed with 2 dp (or more if you want more).
- Status
Similar threads
- Locked
- Question
- Locked
- Question