That's what I first thought, and then I copied the data into the second query, and also just ran some test SELECT statements and thought for sure I had covered...

I have no way to provide sample data that will recreate the problem.   In fact, that 2nd query result was nothing but the following:

SELECT 'ASSBLY', RTRIM('SN5B3 ASSBLY'), '820035021', 'A' UNION...

I think the problem here is that you haven't really defined exactly what you have for data.   You are asking to break out a given column, but then don't specify...

Finally fixed the problem.   Had to Dim newrow As String() first.   That solved the problem.   All I've got left to do now is to fix the column alignment in the...

So here's the latest version of the code:

Private Sub ImportButton_Click(sender As Object, e As EventArgs) Handles ImportButton.Click

Dim da As OleDbDataAdapter
Dim conn As OleDbConnection = Nothing
Dim sheet As...

Found the OLEDB answer on StackOverflow.   Turns out the Extended Properties portion of the connection string needed to be enclosed in quotes.  Of course, that only got me past the...

Thanks for that.  Unfortunately, I can't use T-SQL for this, as the file needs to go on the user's machine as opposed to on the server.  We need this as...

Okay, so to mash together Sue's input and Chris's, I can just create the login for the domain group on the SSRS Server, and then apply permissions to that login...

Given that disk space, in relative terms, is cheap, and network bandwidth is expensive, I'm not sure the considerations here are properly focused.   Handing off the data storage problem invokes...

Okay, that's a good resource on users without logins.  Thanks for that.   Still not sure I understand the reason one would choose to use that ability, so maybe you can...

I'm an idiot.   I just now realized that the sproc in question did not have a GO statement to end the procedure and thus the GRANT statements that were part...

Without any test data to work with, and for both scenarios (you have enough rows, and, you don't), there's not a lot of incentive for anyone to try and figure...

Okay, but then why would the existing user like this script out that way?   Did those logins perhaps "used to exist" ?