Custom Table fields Upload

[former_member593777]

Hi all,

I am having one custom table around 350 fileds, am trying to upload the data to the table using Excel file, but excel is not allowing more than 256 fields. Only i can update 256 fields at a time, again if am updating the table for the same record with all the key fileds plus remaining fields(350-256=94) the previous values are going to be overwritten ie. empty values are coming.

could you please sugges how to upload all the 350 fields at a single time or how to avoid overriding when updating the fields in second time.

Thank you all ...

Regards,

Phani.

[Former Member]

Hi,

What you can do is use MODIFY command for the 94 fields.

So that it will only insert the new values in 94 fields.

REWARD IF USEFUL

[former_member593777]

Hi,

Thank you for your reply, i am using modify statement only...but still the data is over riding.

regards,

Phani.

[Former Member]

Hi,

Is it mandatory to use Excel ? Cant yyou use Text file ?

Please try ....!!!

[Former Member]

Hi

Read both the files in one go ; eg file1 (256 col) and file2 (key fields + 94 col).

Merge the read data in to a single internal table and use the insert/ modify statement.

This would work!!!

Regards,

Girish

[Former Member]

Once you have already inserted a record in a table with primary key. Use the update statement to insert some more fields in the same record.

Statement is.

Update ztable( database table) set field1 = itab-field1 ( field to be populated later)

field 2 = itab-field2 ( field to be populated later)

where a = itab-1

and b = itab-2.

( all the primary keys of the table in where condition).

Better check the document using for update command.

If this does not work out.

Put commit work after modify statement.

Regards.

D.Mallick