odd problem with DTS from Excel -> SQL -- sql server dts

Roy Harvey
7/27/2006 10:50:30 AM

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"
[quoted text, click to view]

Roy Harvey
7/27/2006 11:48:32 AM

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
[quoted text, click to view]

SP
7/27/2006 2:10:01 PM

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

Davide
7/27/2006 3:31:46 PM

Hello peter,

[quoted text, click to view]

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 .

By

peter walker
7/28/2006 12:00:00 AM

Thanks for the tip, much appreciated!

peter

[quoted text, click to view]

peter walker
7/28/2006 12:19:15 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : odd problem with DTS from Excel -> SQL