Help, Problem importing from Excel into SQL 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Help, Problem importing from Excel into SQL 2000

Author

Topic

pharoah35
Yak Posting Veteran

81 Posts

Posted - 2003-06-27 : 09:58:58

Hello

I am attempting to import data from an Excel spreadsheet into SQL 2000
I have 1 spreadsheet with 6 column headings

ProdID, Customer, Vendor, EffDate, EndDate, FixedPrice

I SQL Table with the same columns

ProdID int
Customer nvarchar
Vendor varchar
EffDate datetime
EndDate datetime
FixedPrice money

When I attempt to import the data from my spreadsheet into the SQL table using DTS, I get the following error:

Error during transformation 'DirectCopyXForm' for row number 66.
Errors encountered so far in this task: 1
TransFormCopy 'DirectCopyXForm' conversion error:
Destination does not allow NULL on column pair 1 (source column 'ProdID' (DBTYPE_R8), Destination column 'ProdID' (DBTYPE_14))

Is there another way to import data into a SQL table which has a no NULL.

Any help concerning this issue would be greatly appreciated.
Thanks in advance

pharoah35

mr_mist
Grunnio

1870 Posts

Posted - 2003-06-27 : 10:05:09

Find the blank cells in the excel file and put a value in them, or apply a default value for the not null column on the table. ?

-------
Moo.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources