importing text files into Access table

E

Eck

Hello!...I have imported an Excel text file with numbers which have decimals
(example: 2.3) into Access as a separate table. However, when I open the new
table, the number has been rounded to 2.0. How can I keep the original
decimal format? (btw, if I import as a text field, no problem but of course
you can't do any calculations then). Your advice is greatly appreciated.
 
J

Jerry Whittle

Try changing the problem fields in the Access table from Integer or Long
Integer to Double. Delete all the records then reimport the data into table.
 
E

Eck

Thanks Jerry...worked like a charm!......how do you know stuff like this?!!??
(I found no indication of your "fix" in Access Help etc)....many thanks again
 
J

Jerry Whittle

I learn from my mistakes. Actually only about half of them or as many as I've
made, I'd be a genius! ;-)
 
Top