Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connect old excel data with new sql dat

Hello for all:

I have an script connected to an excel file, I created a lot of tables since 2007 and now i have to connect this old information to an SQL database.

I dont know how can i do, can yo help me?

Thanks.

1 Reply
Not applicable
Author

Hi,

you have to establish a OLE DB or ODBC connection to your SQL database. That´s a job your system or database administrator can help.

Is the connection established open QV script choose connect and a connect string will be placed in your script. Than chosse "select" and look for the tables an fields you need. And be sure that you know what are the right key fields toconnect to your old data.

Good luck!

Rainer