Hi Ralph, [Ralph Hulslander wrote]
> Subject: ERROR 25319 Missing Data > > What do I do when there is no Data in a column? > Importing from MS Access Table. > > FASTLOAD TABLE DOCS > DOCID 1 > DEVICEID 2 > PATH 3 > DOCNAME 4 > OLDDOCNAME 5 > INFILE 'D:\PF_SAPdB\Docs3.csv' COMPRESSED > > / * > / E -25319: Missing data for specified column OLDDOCNAME. > / M Error at line 58 in infile. > > Line 58 only has four column of data column OLDDOCNAME is empty. > > "87","1.16376702.185394463","XXXXXXXXXXXX","thank you 3", > "94","1.16306345.186400499","YYYYYYYYY","Shop Tag 2", > an empty value in a data file is for RepMan defined as a value of length 0. If you specify delimiters you need to include your empty values in these delimiters, too. So your data should look like this: "87","1.16376702.185394463","XXXXXXXXXXXX","thank you 3","" "94","1.16306345.186400499","YYYYYYYYY","Shop Tag 2","" I suppose that other records in your data file contain a value for this column. Thus you can't leave the column name out of the FASTLOAD command. An alternative would be to leave the delimiters completely out on exporting the data. Then your data would look like 87,1.16376702.185394463,XXXXXXXXXXXX,thank you 3, and the empty value would get inserted. HTH. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
