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! ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
importing a text file witnh european number formats 1
Import failing on decimals 1
Numbers/Currency import into Access as text 3
How to export table from outlook into ms access table? 0
Decimal Truncation Issue upon Import - Access 2007 1
Import files into access 1
Access stripping decimal places in query 1

Back
Top