Hi everyone,

I have a problem with a DTS process which imports from excel to SQL. I have
tried this dts process on both SQL 2000 and SQL 2005, and they appear to
both be behaving the same odd way.

The DTS process never is able to pick up any data residing on row '1' of the
excel spreadsheet. I have to always shift all the data down one row so it
starts on row 2, then all is ok.

Would anyone know why this is so?

Many thanks
peter

I have always had to have column headers as the first line. I never
found a way to avoid it, but then I never looked all that hard.

Roy

On Fri, 28 Jul 2006 00:19:15 +1000, "peter walker"
<p.walker (AT) nospam (DOT) com> wrote:

Hello peter,

Before setting the datapump Transformation you should, using Diconnected
Edit, modify your MS Excel connection in such a way:

OLE-DB Properties --> Extended Properties : Set 'HDR=NO' (you should find
'HDR=YES' that is the default)

After this creae the DataPump Transformation .

Bye

Great, thanks for sharing that one, I never had a clue that there were
any such settings.

Roy

On Thu, 27 Jul 2006 15:31:46 +0000 (UTC), Davide
<rossetti71 (AT) gmail (DOT) com> wrote:

Great!! Thanks for sharing, i never knew after working for so long as DBA
that you have this choice too. Good job David

SP

Thanks for the tip, much appreciated!

peter

"Davide" <rossetti71 (AT) gmail (DOT) com> wrote