Skip to Content
0
Former Member
Feb 20, 2009 at 07:00 AM

Best method to update database table for 3 to 4 million rows

1542 Views

Hi All,

I have 3 to 4 million rows are there in my excel file and we have to load to Z-Table.

The intent is to load and keep 18 months of history in this table.

so what should be best way for huge volume of data to Z-Table from excel file.

If is from the program, is that the best way use the FM 'GUI_DOWNLOAD' and down load those entries into the internal table and directly do as below

INSERT Z_TABLE from IT_DOWNLOAD.

I think for the huge amount of data it goes to dump.

please suggest me the best possible way or any psudo code to insert those huge entries into that Z_TABLE.

Thanks in advance..