Importing scattered Data from the Excel File / Sheet - DML (SELECT, INSERT, UPDATE, DELETE) Questions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » Importing scattered Data from the Excel File / Sheet

Importing scattered Data from the Excel File / Sheet

Options

Previous Topic · Next Topic

sandesh27uk

Posted: Thursday, July 19, 2007 7:56:58 AM

Rank: Newbie

Joined: 7/19/2007
Posts: 1
Points: 3
Location: UK

Hello Gurus,

I wonder if anybody has come across / achieved importing very much scattered data form excel file using SSIS. Scattered I mean by reaching to the particular row and particular column and then referencing it to the another row and column and then import the (no) number of rows from then....

I know its weary but that's what is the requirement and I am facing the wall to make it happen. I tried all, providing them the template and stuff... Also tried using the mediating excel file to have linked data. but then there are going to variable many more files to come in future and obvious their names are going to be different.

PLEASE HELP ME...

Sandesh Kadam
Database Developer
Pasa Devlopment Team
NHS Purchasing and Supply Agency

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.