Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Skip unique row on BULK INSERT, any way?
MLS_ID- realty205
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Skip unique row on BULK INSERT, any way?
Really what I need to do is check against the SQL table "property". That's where the error will occur. If I try to add the same data currently in the database from a textfile.- realty205
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Skip unique row on BULK INSERT, any way?
I get the following when I run that query: (0 row(s) affected) (21 row(s) affected) Msg 2627, Level 14, State 1, Line 10 Violation of PRIMARY KEY constraint 'PK_Property_1'. Cannot insert duplicate key in object 'dbo.Property'. The statement has been terminated.- realty205
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Skip unique row on BULK INSERT, any way?
I could use a temp table but don't know how. Could you give me some syntax? Also, what is this doing? SELECT * INTO #Test FROM Property WHERE 1 = 0- realty205
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Skip unique row on BULK INSERT, any way?
I have a table that has a unique primary key. When I do a BULK INSERT from a text file if an identical row/primary key is found the INSERT errors out and nothing gets added. I need to just skip that row from the text file and keep on trucking. Does anyone have an idea? BULK INSERT Property...- realty205
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
-
Can you do an Excel Data Import using vbscript?
I was hoping that I could do an Excel Data Import utilizing vbscript. Does anyone know if this is possible? Anyone have a sample? -
Adding comma behind numbers in a text file?
Horrible right now but this did it: Const ForReading = 1 Const ForWriting = 2 Dim info Dim MLS Dim editMLS Dim Remainder Dim final Dim writeit Dim strText Dim price Dim editPrice 'Create a File System Object Dim fso Set fso =... -
Adding comma behind numbers in a text file?
I was actually able to do that part. I decided to go with pike characters so that I could differentiate the price comma from the others. I want to import this into excel. In VB.Net I can do things like substrings. Is there anyway to pinpoint a specific character? I was thinking RIGHT() but... -
Adding comma behind numbers in a text file?
But wouldn't I need to iterate through each line of the text file? -
Adding comma behind numbers in a text file?
I am having difficulties in trying to add a comma behind a 6 digit number at the front of every line in a text file. Does anyone know of a good way to do it? 394923 3517 Redman Hall Rd, Pinson, AL Photo Added $28,900 394212 828 49th St, Birmingham, AL Price Changed $17,610 395814 818 85th...
