problem in transfering excel file data to SQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

problem in transfering excel file data to SQL

Hello <br /><br />we want to create a DTS package which will transfer all the contents of excel file to a table in SQL server.<br /><br />There are approx 200 excel files, whoes data has to be transfered to SQL. <br /><br />these files contains yearly data of the company. the filename is same as company name.<br /><br />every year 5 column are appended to the files.<br /><br />we have to create a package which will transfer the data from all these files to a table in sql server.<br /><br />We have created 2 packages, one parent and another is child. parent packages retrives the file name from table( we have stored all the file names in a table) and passes it to the child package. the child package then transfer the data from excel file to the table named ‘ExcelData’.<br /><br />The main problem is : while transfering the data by default the packages takes the first row entries as column names, and in all the excel files the first row is company name as heading. <br /><br />so when the data comes to the SQL server, we can not make out which data is for which column. <br /><br />Can any one help me in this matter. if u have any other suggestions pls do let me know.<br /><br />Thanks in advance<br /><br />Pallavi<br /><br />[<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]<br />
I’ve moved to right forum.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
As an alternative, try this Madhivanan Failing to plan is Planning to fail