Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Excel FIle Upload

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-06-23 : 08:13:33
Dear All,

I wane one simple procedure with FileName parameter by which i can upload the excel file in SQL Server.

Please help me

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-23 : 08:15:20
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-06-23 : 08:25:50
Thanks for the article but i need to upload the excel file in SQL but in your article you have shown how to export files from SQl to Excel

Please help
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-23 : 08:31:10
quote:
Originally posted by sanjay5219

Thanks for the article but i need to upload the excel file in SQL but in your article you have shown how to export files from SQl to Excel

Please help


Read it again. I have shown all possible methods

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-06-26 : 14:47:12
Hi,

I have tried but getting this error

oledb provider "microsoft Jet Oledb 4.0" for linked server "null"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-28 : 02:32:55
Can you post the code you used?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -