excel to sql

[tyagishaila]

hello,

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

if yes how?

Thanks

[anbu1984]

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

[alexandros17]

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

[vikasmahajan]

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

Vikas

[tyagishaila]

YES Anbu

[tyagishaila]

Thanks for reply

could you explain more, How it can be done?

[tyagishaila]

Thanks for quick reply Vikas,

I have Microsoft SQL Server Management Studio.

Could you tell me steps to do this conversion?

[sujeetsingh]

Follow this link

SQL Writeback from QlikView extension object.

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

[vikasmahajan]

Hii

Please go through screens explained in jpgs

Hope this helps you.

Vikas

[vikasmahajan · Accepted solution]

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

Vikas