Post reply

DTS Excel with 3 worksheets into SQL Server 2000 database

  • March 1, 2006 at 6:31 am

    #68293

    Hi I have some 4 or more EXCEL spreadsheets with 3 different worksheets, data of which if I have to load into a temp table.I have manage to create a dts that does export the first worksheet of all the spreadsheets into the database in one process.

    However, the aim is to be able to export the 3 or more worksheet to three different database tables within one operation. Any help is well apprecaited.

  • March 1, 2006 at 6:50 am

    #623932

    Are all fixed in format? Do you know the worksheet names?

  • March 1, 2006 at 7:04 am

    #623938

    All are not in a fixed formats as most are text field. All worksheet names are known

  • March 2, 2006 at 6:58 am

    #624285

    We perform similar functions and how we accomplish that task is to insert the data using a oledb connection like this:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFile & ";Extended Properties=Excel 8.0;

    With this connection you can insert ,update, or delete the table(sheet).  Hope this helps

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply