Hi,
Is it possible to concatenate data in every cell of the
first row(Header excluded) with a space in order to
covnert the data to Text Type? If yes how do we select
only one row in Excel
Cheers
Sunny

Not quite sure what you are doing but you could

Given an XL sheet of

A
B
C

Dt
Dt
Dt



(A,B,C) = column headers


We do not want the headers but I want to concat the (Dt,Dt,Dt)

In My datapump I said (Last tab of the datapump)

First Row = 1
Last Row = 1

You can then choose what to do with that row.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Sunny" <Sunnyboy63 (AT) yahoo (DOT) com> wrote