SQL Server Performance

problem in transfering excel file data to SQL

Discussion in 'SQL Server DTS-Related Questions' started by pallavi, Nov 8, 2005.

  1. pallavi New Member

    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 />
  2. Luis Martin Moderator

    I've moved to right forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    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.



  3. Madhivanan Moderator

Share This Page