Hi bud, thanks for the reply.

The destination table already has data in it, so I really just want to append the imported data from the source to the destination.I did the following:

1) Left the Identity field out of the Excel source file

2) Defined the spreadsheet as source

3) defined the SQL database as destination.

4) selected "copy tables and views..."

5) selected my source sheet (eg. tblExcel)

I only have 1 row in this source excel file.When I select “Preview”, this single row appears ok.I only want to import this row, to get me started.

I then click on “transform” > “Append rows to destination Table”

I also click on “Enable Identity Insert”

I get the following error:

TransformCopy ‘DirectCopyXForm’ conversion error.

Destination does not allow NULL on column pair 3 (source column ‘field3’ (DBTYPE_R8), destination column ‘field3’ (DBTYPE_14)

I get this error, regardless of whether I click on “Enable Identity Insert” , or not.

In the single row that I am pathetically trying to import, the ‘field3’ column value is not null, it is 1.

SCHEMA

Excel SOURCE file

field2

field3

SQL Server DESTINATION table

IdField (field1)

field2

field3

This is doing my head in.Does anyone know why it is trying to insert a NULL value, when I can plainly see from the preview that the value of ‘field3’ is 1?

Any help greatly appreciated.

Cheers, yogiberr