March 1, 2011 at 7:06 am
Hi,
I am trying to copy data from SQL Server to Excel.
Until now i have succeded, but in some data 10 records are now pasted into Excel, i think, but not shoore that this data must have some special character that excel ignor.
How can i resolve this, so that Excel accepts the data when i do Paste?
March 1, 2011 at 7:10 am
March 1, 2011 at 7:15 am
It seems to work, but still have a problem.
The data is not on a single column as it should, so its difficult for me to copy and paste it on other Excel sheet
March 1, 2011 at 7:21 am
March 1, 2011 at 7:23 am
What is that?
"paste special/Text"
March 1, 2011 at 7:25 am
No paste especial didn't help...
March 1, 2011 at 7:29 am
March 1, 2011 at 7:52 am
Why dont you write hte query directly in excel and then get results directly from excel itself.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
March 1, 2011 at 7:55 am
hte query?? what is that??
I am not very good working with excel...
March 1, 2011 at 7:58 am
open excel, then data, external data, from other sources...choose sql server
and you can select your table or write your query there..
it will put results directly into excel file.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
March 1, 2011 at 8:16 am
It seems to work but when i pass the Excel to other computer it still shows the connection to SQL Server.
I wanto to extract data , but then want to close the connection and that Excel do not connect to this data source no more....
Is it possible?
March 1, 2011 at 8:23 am
river1 (3/1/2011)
It seems to work but when i pass the Excel to other computer it still shows the connection to SQL Server.I wanto to extract data , but then want to close the connection and that Excel do not connect to this data source no more....
Is it possible?
If you close the excel file , once you got the data, then it cant connect to sql server without you putting the password( windows authnetication/sql server authentiaction) again and trying to reconnect...
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
March 1, 2011 at 8:29 am
Yes, but there that is not the problem...
The problem is:
I have to create a report through excel to send to the CEO of the company.
He wants the report in Excel, but i can not send it to him with the connection object....
It needs to be a normal list of excel.
So, what i want to do is create the excel, connect to SQL Server, extract the data and then finnish the connection and the connection will no longer be needed.
March 1, 2011 at 8:39 am
river1 (3/1/2011)
Yes, but there that is not the problem...The problem is:
I have to create a report through excel to send to the CEO of the company.
He wants the report in Excel, but i can not send it to him with the connection object....
It needs to be a normal list of excel.
So, what i want to do is create the excel, connect to SQL Server, extract the data and then finnish the connection and the connection will no longer be needed.
I dont get you..whats the problem, just create the report out of excel, save the file and send the excel file to him...??
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
March 1, 2011 at 8:43 am
hum...
Or i don't undestand you or you don't understand me 🙂
I will explain again
I have a excel file which , with your help i connected to SQL Server 2005.
I have extracted the data to Sheet1.
Now i want to save this excel file and don't want that the excel file that i have saved tryes to connect to SQL Server the next time i open it...
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply