Losing decimals when importing

External Since: Dec 11, 2006 Posts: 5

I frequently import .csv files into Access that I have formatted as
General in Excel. I notice I am losing the decimals when I import.
Could someone tell me how to keep the decimals? I have seen a few
similar posts, but nothing that seems to address this exactly.

Thanks.

External Since: Jul 14, 2008 Posts: 237

Your fields in your Access table are probably set as a long integer data
type. Open your table in design view and set the data typs for your fields
as Single if your data is less than 32000 or as Double if your data is
greater than 32000.

Steve

wrote in message

>I frequently import .csv files into Access that I have formatted as
> General in Excel. I notice I am losing the decimals when I import.
> Could someone tell me how to keep the decimals? I have seen a few
> similar posts, but nothing that seems to address this exactly.
>
> Thanks.