Hi,

I am having a strange problem while importing Excel into SQL Server2000
I have created a DTS that does nothing any more complicated than importing
Excel data direct into a table.

The table consists of a number of colums but here are the ones that I am
having problems with

InsID int
ID int
Type varhcar(20)

When I import the the data it's putting the correct values in the type field
and the InsID field but missing out the corresponding ID value, I have read
about the fact that if DTS does not find a value in the first 8 rows it
thinks that there will be nothing in that column full stop, but I have also
added and ActiveXScript that changes the way the column is looked at, please
find the scrips below -:

Function Main()

dim pkg
dim conXL
dim prp

set pkg = DTSGlobalVariables.Parent

set conXL = pkg.Connections("Microsoft Excel 97-2000")

conXL.ConnectionProperties("Extended Properties").Value = "Excel
8.0;HDR=NO;IMEX=1"

Main = DTSTaskExecResult_Success
End Function

I have also tried changing Extended properties value, through the
Disconnected Edit options but still getting the same problem, does anyone
else have any ideas what I can try?

Thanks is advance, Phil