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.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-08-09 : 14:26:47
|
| I'm just re-posting from a different forum this since I've got a couple things I've figured out what was wrong.Here's what I have to do: 1. Allow user to locate a .xls file on their machine 2. Upload this .xls data into an existing table on a remote SQL Server I can pull the file from my local machine to another directory on the local machien, but can't figure out have to configure the saveas() to save on the remote db server. It seems you have to save the the db server first on the hard drive, then you can insert the .xls file data into the table. Here's my code so far that works to save on the local machine to another directory on that local machine: Dim getmyFile As HttpPostedFile = myfile.PostedFile If IsNothing(getmyFile) Then Label2.Text = "Please select a file to upload" Else If getmyFile.ContentLength = 0 Then Label2.Text = "Cannot upload zero length File" Else Dim ServerFileName As String = Path.GetFileName(myfile.PostedFile.FileName) getmyFile.SaveAs("C:\TestSaving\" & ServerFileName) Label2.Text = "Successful upload to C:\TestSaving\" & ServerFileName sCon1.Open() Dim strSQL As String Dim err As Integer strSQL = "Insert into ActivityTest Select * FROM OPENROWSET" strSQL &= "('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\testing.xls;" strSQL &= "HDR = YES ','SELECT * FROM [Sheet1$]')" Label3.Text = strSQL.ToString() Dim cmd As New SqlCommand(strSQL, sCon1) Try cmd.ExecuteNonQuery() err = "Select @@Error" If err <> 0 Then Label4.Text = err.ToString() Else Label4.Text = "No Error...line 91!" End If Catch ex As Exception Label2.Text = "Line 82 Error Updating Table: " Label2.Text &= ex.Message Finally sCon1.Close() End Try End If Any books that you know of to help with this topic, since I'm sure I'll be doing more of it in the future, will be apppreciated too!Thanks for the help in advance!!!! |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-09 : 14:52:08
|
| Look at ASPSmatUpload.====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-08-09 : 15:00:22
|
| will this work with .NET? |
|
|
|
|
|
|
Upload .xls file to SQL Server table w ASP.NET app