topic Re: excel to sql in QlikView

excel to sql

tyagishaila — Wed, 18 Feb 2015 07:43:04 GMT

hello,

I want to know is it possible to convert .xlsx file into .sql with the help of qlikview.

if yes how?

Thanks

Re: excel to sql

anbu1984 — Wed, 18 Feb 2015 07:45:34 GMT

What do you mean .xlsx to .sql? Table into insert sqls?

Re: excel to sql

alexandros17 — Wed, 18 Feb 2015 07:47:50 GMT

Yes even if this is not the objective of Qlik.

1) First load the excel file

2) write a query to insert data into a sql table

You can do it directly from SQL or you could load xlsx to access then insert into sql

Hope this helps

Re: excel to sql

vikasmahajan — Wed, 18 Feb 2015 07:55:36 GMT

In SQL there is import / export facility available you can directly import excel into Table through this utility.

Vikas

Re: excel to sql

tyagishaila — Wed, 18 Feb 2015 08:46:58 GMT

YES Anbu

Re: excel to sql

tyagishaila — Wed, 18 Feb 2015 08:47:59 GMT

Thanks for reply

could you explain more, How it can be done?

Re: excel to sql

tyagishaila — Wed, 18 Feb 2015 08:50:12 GMT

Thanks for quick reply Vikas,

I have Microsoft SQL Server Management Studio.

Could you tell me steps to do this conversion?

Re: excel to sql

sujeetsingh — Wed, 18 Feb 2015 08:59:05 GMT

Follow this link

SQL Writeback from QlikView extension object.

http://community.qlik.com/message/135858#135858

Re: excel to sql

vikasmahajan — Wed, 18 Feb 2015 09:10:07 GMT

Hii

Please go through screens explained in jpgs

Hope this helps you.

Vikas

Re: excel to sql

vikasmahajan — Wed, 18 Feb 2015 09:11:21 GMT

Hope this steps will helps you to import excel into SQL.

Vikas

Re: excel to sql

tyagishaila — Wed, 18 Feb 2015 09:40:27 GMT

Your reply is really very valuable and helpful for me.

I follow all steps as you suggest..

but in my sql database dbo.sheet1$ is not showing

while no error occurs during process.

Re: excel to sql

tyagishaila — Wed, 18 Feb 2015 09:57:38 GMT

Great Vikas,

It has done..

Thanks Thanks a lot.

Regards,

Shaila

Re: excel to sql

vikasmahajan — Wed, 18 Feb 2015 11:12:50 GMT

Welcome