Hi friend,
As, i want to import sql database value to excel, in comment format to display text in excel sheets.
please any one help me.
I don't know if it possible to write sql query or directly import in excel sheets.
please any one help me to solve this solution.
I got sql database value to excel sheets its working but, i need one excel sheets column to display text as comment(from sql database value to display as comment).
How it possible? If it write sql query or directly get from excel sheets?
If any one help me.
Loading
sharmila kPosted Oct 19, 2012, 3:24 AM
In excel sheets insert comment function is there.
same like i want to import sql database value to excel that time, display sql database value to excel sheet comment.
Now u got it.
In excel you right click insert comment is there.what ever comment u need just u type there.
But, i need to display that comment as sql database value.
same like when i import sql database value to excel at that display sql database value in comment excel sheets column.
Vithal WadjePosted Oct 19, 2012, 2:39 AM
sharmila kPosted Oct 19, 2012, 2:31 AM
Thank u for your replay.
I got sql database value to excel sheets its working but, i need one excel sheets column to display text as comment(from sql database value to display as comment).
How it possible? If it write sql query or directly get from excel sheets?
If any one help me.
sharmila kPosted Oct 19, 2012, 2:31 AM
Thank u for your reply.
I got sql database value to excel sheets its working but, i need one excel sheets column to display text as comment(from sql database value to display as comment).
How it possible? If it write sql query or directly get from excel sheets?
If any one help me.
Vithal WadjePosted Oct 19, 2012, 2:20 AM
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [SheetName$]') select * from SQLServerTable
if answer is helpful then Mark it
Satyapriya NayakPosted Oct 19, 2012, 2:18 AM