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

B

Bill

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?
 
K

KARL DEWEY

Check the datatype. It is probably defaulting to Number - Interger. You
will need Number - Single or Double.
 
B

Bill

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
 
Top