Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: slesniak123
- Order by date
-
-
Reading and excel spreadsheet
Hello, I am very new to vb .net and i am trying to write and application that can do the following: Part 1 Browse for an .xls file Read xls and parse data needed Import to sql database Part 2 Have an a couple of input fields and query SQL based on the ones filled out Based on query results...- slesniak123
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
Need Help with importing EXCEL
Thank you very much for your response, it was very helpful. I have just created a SSIS package and everything is working except for one part, i am trying to insert some data into a table but i keep getting this error: "No disconnected record set is available for the specified SQL statement." I...- slesniak123
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Need Help with importing EXCEL
Hello, I am very new to sql server 2005, and i wanted to know if anyone can help me in creating a SSIS packge that can do the following: 1. Import an excel sheet 2. Delete uneeded columns 3. Merge two fields together, only if first column is not null, and if it is null delete that record. 4...- slesniak123
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
