Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with an Excel file in a DTS

Status
Not open for further replies.
AnaFlor

AnaFlor

Programmer
Mar 17, 2004
65
PT
Hello,

I have a DTS where I wanted to pass the information of an excel file to a temporary table.
The problem is that my excel file don't have column names, the first row has values as well.

How can I configure it so it let me pass the first row as values instead of the column headers?

Thanks
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
194
grnzbra
grnzbra
tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
160
tekpr00
tekpr00
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
252
gk53
gk53
petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
162
petart
petart
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
199
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top