Re: DTS - Excel file path from a table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: MS User (sqlman_at_sql.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 17:05:32 -0600

Thanks Allan

My Excel sheet contains different sheets and I just want to read one sheet
to load into table. Thoughts/Ideas ??

Thanks

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:eAuNYX74EHA.828@TK2MSFTNGP14.phx.gbl...
> You would probably want to have a look at these two articles then.
>
> Looping, Importing and Archiving
> (http://www.sqldts.com/default.aspx?246)
>
> How to loop through a global variable Rowset
> (http://www.sqldts.com/default.aspx?298)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "MS User" <sqlman@sql.com> wrote in message
> news:u$ZIoQ74EHA.924@TK2MSFTNGP14.phx.gbl...
>> SQL 2000
>>
>> I got a table with file names and path for the Excel files to be loaded
>> into a sql table.
>> My plan is to use DTS and global variable to assign the path and file
>> name and use that as the source for the data-pump.
>>
>> Any thoughts or sample code to achieve this ??
>>
>> Thanks In Advance
>> Jeff
>>
>>
>
>

Quantcast