importing text files into Access table

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.
 
G

Guest

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.
 
G

Guest

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
 
G

Guest

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 a text file witnh european number formats 1
Importing Text Files Into Access 1
Import failing on decimals 1
Import failing on decimals 1
Importing taxt extract file with Numbers and decimals 5
Decimal Truncation Issue upon Import - Access 2007 1
Access stripping decimal places in query 1
Number formats in exported data 1

Top