Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Megha_More
Partner - Creator
Partner - Creator

Qlik Replicate- Excel as a source

Hi team,

Can we use Microsoft Excel as a source ?

If yes, then which source point ?

 

Regards,

Megha

Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @Megha_More ,

Thanks for reaching out to Qlik Community!

There is NO prebuilt driver for MS Excel files in current Replicate versions. The alternative options are

1. Export the MS Excel files to CSV format files (pre-process step), Qlik Replicate supports the delimited text files as source endpoint.

2. Using the generic ODBC Driver which connect to the MS Excel files. The ODBC Driver can be Microsoft Excel Driver or 3rd party ODBC Drivers. I'm pasting a driver sample below for your reference.

john_wang_0-1702895135270.png

 

BTW, please take note the ODBC endpoint limitations and going through Professional Services and approved by your Account Manager .

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

7 Replies
john_wang
Support
Support

Hello @Megha_More ,

Thanks for reaching out to Qlik Community!

There is NO prebuilt driver for MS Excel files in current Replicate versions. The alternative options are

1. Export the MS Excel files to CSV format files (pre-process step), Qlik Replicate supports the delimited text files as source endpoint.

2. Using the generic ODBC Driver which connect to the MS Excel files. The ODBC Driver can be Microsoft Excel Driver or 3rd party ODBC Drivers. I'm pasting a driver sample below for your reference.

john_wang_0-1702895135270.png

 

BTW, please take note the ODBC endpoint limitations and going through Professional Services and approved by your Account Manager .

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Megha_More
Partner - Creator
Partner - Creator
Author

Hi @john_wang ,

Thank you for the response, will check with the same.

 

Regards,

Megha

john_wang
Support
Support

Hello @Megha_More ,

Thanks for the feedback. Feel free to let me know if you need any additional assistance.

Best Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
raghujakkani
Contributor III
Contributor III

Hi John,

 

When using 2nd option - ODBC Driver. What is the Source type should be opted ? 

 

Thank you,

Raghu. 

john_wang
Support
Support

Hello @raghujakkani ,

The generic ODBC source endpoint can be used. for example:

john_wang_0-1710554003033.png

The type is "ODBC", and you may choose a pre-defined 64-bit ODBC DSN (in above sample it's "VSAMOFF"). Or you may compose the ODBC Connection String manually.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
raghujakkani
Contributor III
Contributor III

We have installed Microsoft 365 Access Runtime, Excel Driver is part of it. We were able to create a DSN using ODBC Data Source Administrator. 

raghujakkani_1-1711052465111.png

But when browsing to select the database for source connection, it couldn't find it. Are we missing anything here ?

raghujakkani_0-1711052436496.png

 

john_wang
Support
Support

Hello @raghujakkani ,

Please create SYSTEM DSN so far you may choose it from Replicate Endpoint Management GUI.

thanks,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!