If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I tried the article, and have the following in the button click event to Upload:
Dim iLength As Integer = CType(myfile.PostedFile.InputStream.Length, Integer)
If iLength = 0 Then Exit Sub 'not a valid file
Dim sContentType As String = myfile.PostedFile.ContentType
Dim sFileName As String, i As Integer
Dim bytContent As Byte()
ReDim bytContent(iLength) 'byte array, set to file size

'strip the path off the filename
i = InStrRev(myfile.PostedFile.FileName.Trim, "\")
If i = 0 Then
sFileName = myfile.PostedFile.FileName.Trim
Else
sFileName = Right(myfile.PostedFile.FileName.Trim, Len(myfile.PostedFile.FileName.Trim) - i)
End If

******************************
I'm not seeing anything in the table. Do I have to do something with the Parameter Collection for the Insert Statement? The value spot is left blank, and the name looks like it should be: FileName, FileSize, FileData.........do these need to be @FileName, @FileSize, @FileData...?

All I need to do is take the rows / data from the .xls file and insert them into the database table. So, if the table has 5 rows as of now, and the .xls file has 10 rows, once I have the user click the "Upload" button, I want 15 rows in the table.

The question is: Can you read the rows/data from the .xls file WITHOUT writing the file to the disc? Perhaps from a buffer/memory? then you can either save the stream into the DB or discard it - all the while without needing filesystem permissions. ???

Can you read the rows/data from the .xls file WITHOUT writing the file to the disc?

The file already exists, so there would be no need to recreate it. It would seem to me that you could use VB.NET to read the rows you want into a datareader and then write the contents of the reader off to a database table.

I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section. Please use [Code]your code goes in here[/Code] tags when posting code.Before posting your question, did you look here?Got a question on Linux? Visit our Linux sister site.Modifications Required For VB6 Apps To Work On Vista