topic Re: Custom Table fields Upload in Application Development and Automation Discussions

Custom Table fields Upload

former_member593777 — Thu, 01 May 2008 06:00:23 GMT

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.

Re: Custom Table fields Upload

Former Member — Thu, 01 May 2008 07:32:07 GMT

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

Re: Custom Table fields Upload

former_member593777 — Thu, 01 May 2008 07:56:48 GMT

Hi,

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

regards,

Phani.

Re: Custom Table fields Upload

Former Member — Sat, 03 May 2008 23:48:07 GMT

Hi,

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

Please try ....!!!

Re: Custom Table fields Upload

Former Member — Sun, 04 May 2008 09:37:44 GMT

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

Re: Custom Table fields Upload

Former Member — Sun, 04 May 2008 10:02:26 GMT

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