Access Imports from Excel as text, loses decimal when converting b

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

Guest

Company recently upgraded to Office 2003. Now when I import from Excel,
Access loads numbers as text. When I try to reset to number format I lose my
decimal place. Never had problems with Access 2000.

Am I missing something here?
 
Check the datatype. It is probably defaulting to Number - Interger. You
will need Number - Single or Double.
 
Thanks Karl - it seems that it was a parsing error from the original data
files - those cute little green triangles were there too to warn me but I
wasn't used to seeing them.

Bill
 

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

Access stripping decimal places in query 1
Importing taxt extract file with Numbers and decimals 5
Decimal Truncation Issue upon Import - Access 2007 1
Numbers/Currency import into Access as text 3
Import from Excel - Access Adds Extra Decimal Places? 2
How do I keep leading zeros and remove the decimal point when expo 2
Import errors from Excel 3
Access to Excel currency field loses decimal formatting 4

Back
Top