topic How to load data from tables pre-defined in excel template in App Development

How to load data from tables pre-defined in excel template

vikasmahajan — Thu, 13 Jan 2022 05:54:28 GMT

Hi All,

Can any one provide me a script for extraction with data dictionary , data will be taken from excel template with table names & list of fields to be loaded along with incremental load.

Thanks in advance

Vikas

Re: How to load data from tables pre-defined in excel template

Pillow410 — Thu, 13 Jan 2022 04:46:08 GMT

In Excel, select Data > Queries & Connections, and then select the Queries tab. In the list of queries, locate the query, right click the query, and then select Load To. The Import Data dialog box appears. Decide how you want to import the data, and then select OK.

skylight paycards

Re: How to load data from tables pre-defined in excel template

vikasmahajan — Wed, 12 Jan 2022 14:03:26 GMT

Hi Pillow410,

Thanks for your reply I am looking for solution like i will define my tables & columns in excel template & wanted to fetch those table & columns from SQL.

Regards

Vikas