By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,730 Members | 1,567 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,730 IT Pros & Developers. It's quick & easy.

download a file from a web browser (IE) and upload in MS SQLSERVER

P: 1
I have to download a file from web and upload in MS SQLSERVER 2005. However, the problem i am facing is that the file i download in in web page format though it shows excel format. I have to open the file and save as excel workbook and then upload through using following syntax:

1. I use Process.Start("") and i click on download button to download the file and save dialogue appear to save but don't give the possibility to change the format here.
2. To upload i use Myconnection.ConnectionString = "Provider=" & "MICROSOFT.JET.OLEDB.4.0" & ";Data Source= " & lsFileName & "; Extended Properties = ""Excel 8.0;HDR=YES;IMEX=1"""

Can anyone help me as i have to do lots of manual intervention before uploading the file. Thanks in advance

i don't know the syntax to upload from a web file
Apr 8 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.