Home > Archive > MS SQL Server DTS > March 2006 > Select columns name excell









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Select columns name excell
Mauro

2006-03-27, 7:38 am

Hello Everyone,
I have a excel file that has a variable column header name. So, during the
data
transfer, I need to read the column header information in the first row
of the excel file in the Data pump task in the DTS package and set them in
distinct rows of my table.
Is possible to read this column name with a particular select?
Thanks


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com