Hi,
I am importing my Excel data in SQL, problem is the first row of th
Excel sheet is not imported into the database. i think this is becaus
of theheader problem... i haven't given any header so i guess the firs
row is taken as Header and the value is not taken... actually speakin
there is no header to this Excel sheet and i need all the values to b
import into the database.
how to do it?
waiting for ur reply .
thanks,
jay

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48418

Jayender,

How are you trying to import the rows (by means of code or any tool
that does it)
If code, please post a snippet of it

Kalpesh

I am npot doing it by any means of code.. u got an Data Transformation
Services in SQL, with the help am imporing the data.

while doing that the first row is not added to the database


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=484189

Hi,

I guess that is the limitation with DTS. Whereby you cannot tell DTS to
NOT consider 1st row as the field name

IMO, it will be better to write VB code which transfers data from excel
to your db using ADO
Does this help ?

Kalpesh

Ya it does help .
but not much .. am not writing any scrips in VB or something like
that.

anyway thatks dude !!


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=484189