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.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Schildberg, Steffen Sent: Wednesday, October 09, 2002 3:23 AM To: '[EMAIL PROTECTED]' Subject: RE: A little problem with repmcli 25281 error Now 25319 error Hi Ralph, [Ralph Hulslander wrote] > Subject: re:A little problem with repmcli 25281 error Now 25319 error > Now I am getting a 25319 error > > User dba connected to database PFORMS on local host. > FASTLOAD TABLE DOCS > DOCID 1 > DEVICEID 2 > PATH 3 > DOCNAME 4 > OLDDOCNAME 5 > INFILE 'D:\PF_SAPdB\Docs.csv' > > Error during execution > -->-25319 > Missing data for specified column OLDDOCNAME. > You need to include all data in your data file in double quotes or none (thats one of the differences to old xload that came with ADABAS). So your data should look like this (1 example row from test.csv): "1","XXXXXXXXX","EEEEE","duckduck","here". In case you'd like to have no delimiters you need to specify to use no delimiters: FASTLOAD TABLE DOCS DOCID 1 DEVICEID 2 PATH 3 DOCNAME 4 OLDDOCNAME 5 INFILE 'D:\PORTABLEFORMS\test.csv' DELIMITER '' and the data 1,XXXXXXXXX,EEEEE,duckduck,here Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
