myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Extra values being inserted by CSV Import Wizard Options · View
Honestcon
Posted: Monday, January 17, 2011 12:43:17 PM
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?
elian
Posted: Monday, January 17, 2011 1:13:59 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
You csv file is comma delimited
and you try to import using tab delimiter
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.