Load Data from Multiple Excel Files in a Folder from Qlik Replicate

[davinci_rajesh]

Well, I have multiple excel files in a folder and I want to load that data in qlik replicate and then replicate to target sql database. How can i do that?

[john_wang]

Hello @davinci_rajesh ,

Thanks for reaching out.

In general there are 2 approaches in Replicate to read records from files.

1. Configure the source file as regular ODBC DSN, and utilize the generic ODBC DSN to read the files; see more instructions about Using ODBC to connect to a source . (Qlik Replicate does not provide the ODBC driver, you may use other 3rd party 64-bit ODBC driver, or see below option 2.)

2. Configure Replicate to read the source file directly. Replicate supports delimited text files as a source in a replication task, more information can be found at Using a file as a source.

Hope this helps.

Regards,

John.

[narendersarva]

Hi @davinci_rajesh 

Please refer below link for file source end point for excel files as source.

Using a file as a source | Qlik Replicate Help.

Thanks
Naren