Importing CSV to Access

[Jeff]

Hi,

I want to import a csv file into Access. The data in one of the columns is
a "double" but Access imports the field as an Integer.

For example the field value = 0.07 Acess saves the table in the database as 0.

This might be because the first 1000 or so columns are 0 and Acess thinks
the data is integer.

How can this be fixed?

Thanks for your help.

 

[Dennis]

I assume you are you using the import wizard.
If so, go through the wizard until next is greyed out and you are ready to
click the finish button. Before doing so, click the advanced button. This
will give you a list of all the fields and types where you can change the
required field type to double.
Click OK and then click finish

 

[Pete D.]

Quickest way would probally be to pad the first few rows with the correct
formated numbers. Deleting a few records in a table is quick.