Rank: Newbie Groups: Member
Joined: 1/17/2011 Posts: 1 Points: 3
|
I am importing the attached CSV file into an sql database, and get the following error on all fields: INSERT INTO [dbo].[ArchiveCatalogues] ([DATE], [AUCTION], [LOT], [LOWEST], [PUBEST2], [IMAGE], [IMAGE_1], [IMAGE_2], [IMAGE_3], [IMAGE_4], [IMAGE_5], [IMAGE_6], [IMAGE_7], [IMAGE_8], [IMAGE_9], [IMAGE_10], [IMAGE_11], [FIRSTNAME], [ARTIST], [SUFFIX], [TITLE], [MEDIUM], [SIGNATURE], [MEASURE], [ORIENT], [PROVENANCE], [EXHIBITED], [LITERATURE], [NOTE], [EPRICE], [CLICK], [DDS], [FRONTPAGE], [LotId]) VALUES ('20101213,1,300,300-500,1,IMAGE_1,IMAGE_2,IMAGE_3,IMAGE_4,IMAGE_5,IMAGE_6,IMAGE_7,IMAGE_8,IMAGE_9,IMAGE_10,IMAGE_11,Patrick,Scott,HRHA (b.1921),"CHRISTMAS GREETING CARD, 1997",screen print (no. 46),signed and dated in pencil in the margin lower right and inscribed [STW] and numbered lower left,"24 by 21cm., 9.5 by 8.25in.",P,Provenance:A gift from the artist to the present owner,EXHIBITED,LITERATURE,NOTE,420,Click for larger image,1,FRONTPAGE,20101213001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
DEFAULT or NULL are not allowed as explicit identity values. The file I am importing has 34 columns, but there are 67 values inserted, as you can see above. The LotID field is the Identification field and is set not to accept nulls. I am using TAB as the delimiter. Any idea what is going wrong?
|