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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 13 Sep 2005 18:18 GMT

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?

Reply to this Message

KARL DEWEY - 13 Sep 2005 22:41 GMT

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

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

Reply to this Message

Bill - 13 Sep 2005 22:50 GMT

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

> Check the datatype. It is probably defaulting to Number - Interger. You
> will need Number - Single or Double.
[quoted text clipped - 4 lines]
> >
> > Am I missing something here?

Reply to this Message