Importing CSV to Access

J

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.
 
D

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
 
P

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.
 

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

Cannot import CSV file into ACCESS 1
Convert to csv 1
Convert acess table to csv file 1
Ignore apostrophe when importing csv file into Access table 0
Convert a csv to xls prior to import 2
importing data 0
Importing csv 3
Type Conversion Error While Importing (Time Field) 8

Top