importing text files into Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
I learn from my mistakes. Actually only about half of them or as many as I've
made, I'd be a genius! ;-)
 
Back
Top