importing CSV into Access... huh?

B

bigmac

Limp Gawd
Joined
Aug 7, 2001
Messages
447
This is a weird problem. I can't believe it's even happening to me.

I am importing a CSV file into Access. Nothing fancy. Everything goes smoothly. Then I open the resulting table and one of my columns is messed up. It is supposed to contain values from 0 to 1. 1s are okay, but everything else becomes 0.

Here is what my CSV file looks like to begin with:
Code: 
"297298","blah","blah",1
"298299","blah","blah",1
"299267","blah","blah",0.639929176512464
"299299","blah","blah",0.749851081872152
"299300","blah","blah",1
"300299","blah","blah",0.612143749751606
"300300","blah","blah",0.77059571596834
"300301","blah","blah",1

Am I missing something here?
 
I believe that the import wizard only scans the first row when determining field data types. You have a few options: move the third row to the first row in the CSV file; manually specify the field type in the import wizard (Advanced button), or create the table beforehand and import into that table.
 
You must log in or register to reply here.
Back
Top