topic Re: question on custom database table updation in Application Development and Automation Discussions

question on custom database table updation

Former Member — Thu, 30 Mar 2017 11:51:11 GMT

Hi Experts,

I have created a new custom database table and I want to upload 100k records into that custom table , I know we can update that custom table by writing a custom program which reads the records from excel sheet into an internal and update that custom database table from that internal table . Is there any better option or any other way for doing that.

Thanks,

Re: question on custom database table updation

Former Member — Thu, 30 Mar 2017 13:02:44 GMT

LSMW ?

Rich

Re: question on custom database table updation

Former Member — Thu, 30 Mar 2017 14:50:13 GMT

Hi Rich,

Thanks for your reply

Yes I am aware of this option I am looking for some option like we can upload all the contents in excel with the help of excel sheet.

thanks,

Re: question on custom database table updation

Former Member — Thu, 30 Mar 2017 14:51:49 GMT

Hi ,

If you are aware of BRF+ decision table these decision tables have this option where we can upload the table contents using an excel sheet. I am looking for some thing like that.

Thanks,rg

Re: question on custom database table updation

raghug — Thu, 30 Mar 2017 17:51:49 GMT

You can also try third party tools like Innowera and Winshuttle.

Re: question on custom database table updation

former_member228164 — Fri, 31 Mar 2017 06:22:39 GMT

Hey are you using this tool in your company ? btw its a nice tool..

Re: question on custom database table updation

amol_samte — Fri, 31 Mar 2017 07:11:30 GMT

For this bunch of records...program is best way...