Re: BULK INSERT

From: Mike Labosh (mlabosh_remove__at_hotmail.com)
Date: 12/31/04 

Date: Thu, 30 Dec 2004 20:39:21 -0500

> I see the FIELDTERMINATOR option, but the quotes in these files don't
> "terminate" the values, they "surround them", as in quotes on both sides.

Nevermind, I just tried it out and SQL Server is smart enough to use it
correctly for these files. 

-- 
Peace & happy computing,
Mike Labosh, MCSD
"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

Relevant Pages

  • Re: BULK INSERT
    ... >> I see the FIELDTERMINATOR option, but the quotes in these files don't ... > Nevermind, I just tried it out and SQL Server is smart enough to use it ... they *really* want to have all these stupid quotes. ...
    (microsoft.public.sqlserver.programming)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... >I'm sorry that your jerry-rigged spreadsheet program isn't flexible ... Single quotes are used to delimit different syntactic tokens than ... >I'm so sorry that you work for a stupid company; SQL Server is WINNING ... it doesn't take as many IBM mainframes running DB/2 to do the same work ...
    (microsoft.public.excel)
  • Re: Bad data
    ... #2 The Quotes should not be entered into the table as well. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > I am creating a DTS process that will extract data from a ...
    (microsoft.public.sqlserver.dts)
  • Re: Bad data
    ... Formatting Character Data into Datetime fields ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ... > Water industry AWWA ... >>#2 The Quotes should not be entered into the table as> well. ...
    (microsoft.public.sqlserver.dts)
  • Re: Full-Text Search Not Finding Suffix
    ... How do I make it NOT have the double quotes. ... strSearch = "SELECT icgMenuSectionName FROM icgMenu WHERE contains( ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)