|
Hello:
I have a table that whose all the columns, except
for the first two, are fixed data type. And I am loading this table from a csv
file ( structure as shown below). Most of the time the fixed data field is empty
string in the csv file.
0160-050P000,AT01,5744.28,,,,,,417.44,,
0160-050P001,AT01,,,,5744.28,,,417.44,, I am loading this data as:
DATALOAD TABLE $2 INSTREAM PIPE '$3' DELIMITER '
'
When I try to load this empty value into a table's
fixed data field, it gives me an error -25319 - Missing data for specified
column. How do I specify that the default value for the fixed data field is NULL
(specifying default NULL in the table structure does not work)?
I did read the below mentioned article. But I
have almost million records and it is not possible to manually edit the
data.
"
Darn I knew I was overlooking something, thanks.
For the archive it should be noted when exporting from Microsoft Access 2000 that if the first column is a Number then it is not wrapped in the qualifier " this has to added manually. Ralph H. " Thanks,
Vanita
|
