I followed the steps specified in waltz400 on july 13th 2005.

Waltz400 probably said some useful things. If you let us know where he said them, maybe we could see how they relate to your problem. Could you supply us with a link?

But i got a messags saying “CWBTF0005-data in this field incorrect(row1,colomn1)or does not match the pc data type” .

The definition of the database file doesn’t match the data you’re trying to upload. We need to see at least one of the rows you’re trying to upload and the definition of the database file. Without those, we can’t tell anything more than what you already were told — the data in the PC file doesn’t match the description of the database. We can’t guess why that’s true.

sINCE THE FILE SIZE IS BIGGER I COULDN’T SAVE IT AS A TEXT FILE AND UPLOAD.

Since the file size is “bigger” than… what?

What is it bigger than? How does that stop you from saving it as a text file? Does an error message appear? (What message? Where do you see it? When do you see it?)

Tom

Waltz400 instructions will work
1.. create as/400 file
2. download that file to your pc using client access transfer to a cvs file format. That gives you an .fdf file with the description of the transfer
3. save you xls file as a cvs file — doesn’t matter how big it is. Make sure that there aren’t any column heading text or other stray text on the sheet..especially in numeric columns
4. use client access to upload the cvs file to the 400 using the .fdf file you created in step 2.
Phil

thanks phil.

I tried with .csv file as well as .cvs files.
But same message is comming. Yes and the excel file consists of alpha as well as numeric columns in the same record. Pls tell me how to overcome with this problem.

Hi

create your spreasheet as a .prn and make sure you have a .fdf file
and try to upload that way…
if you still having a problem then email me on dmaistry@sn.co.za
send me your excell file and I will give you detailed step by step mon how to sort this problem out..
Cheers

Did you make sure that the fields in the file that you created matched the fields in the spreadsheet? All 25 fields? Also, if you are using iSeries Access, there is an add-in for Excel that lets you transfer files directly to and from the AS/400.

We are just guesing at your proble but if you provide these we maybe able to help more.
1 please post the dds of your file
2. the fdf that you are using
3. a copy of the first 2 lines of the .cvs file
Phil

thank you for all the help

I was able to upload the file through the excel add-in. It is easy no need to save the excel file as.prn or .cvs.
For your information the steps are as follows
Excel – Data – data transfer to iseries

thank you again
priyantha