Re: Simple Bulk Insert
From: Prabhat (not_a_mail_at_hotmail.com)
Date: 09/20/04
- Next message: Uri Dimant: "Re: Simple Bulk Insert"
- Previous message: Hugo Kornelis: "Re: List of bad practices"
- In reply to: Wayne Snyder: "Re: Simple Bulk Insert"
- Next in thread: Wayne Snyder: "Re: Simple Bulk Insert"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 17:42:55 +0530
Thanks Snyder,
We can use DTS for that. But I was looking for any Support in Bulk Insert.
I think We can Do that using "Format File". But I don't know How to create a
format file for that.
Thanks
Prabhat
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:OLUMrkwnEHA.2172@TK2MSFTNGP10.phx.gbl...
> Unless I do not remember correctly neither BCP or bulk insert handle
quoted
> strings.... FOr that I usually go to DTS import which allows you to choose
a
> text input and specify that the columns are quoted..
>
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Prabhat" <not_a_mail@hotmail.com> wrote in message
> news:%23z6uOYwnEHA.1152@TK2MSFTNGP10.phx.gbl...
> > Hi All,
> >
> > I have one TEXT (Source file = D:\V090804.TXT) file which I want to Bulk
> > Insert into SQL Table (Table Name = PLEDGEFILE) of Same Structure.
> >
> > The text file has Data like:
> >
> > "I","0406927277","MR","EUGENE","JUNGBLUTH"
> > "I","0401111111","MRS","PAULA","DICESARE"
> >
> > and My Bulk Insert Statement like:
> >
> > BULK INSERT PLEDGEFILE FROM 'D:\V090804.TXT'
> > WITH (FIRSTROW = 1, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
> >
> > But this is Not working. I think it is treating "I" as value for 1st
> Column
> > [Including "" = Double Quotes.] while My field length is 1 for 1st
column.
> I
> > Don't want the Double Quotes. I want Only the VALUE.
> >
> > Please Suggest How do I Bulk Insert Only Values - Excluding the double
> > Quotes.
> >
> > Thanks
> > Prabhat
> >
> >
> >
> >
>
>
- Next message: Uri Dimant: "Re: Simple Bulk Insert"
- Previous message: Hugo Kornelis: "Re: List of bad practices"
- In reply to: Wayne Snyder: "Re: Simple Bulk Insert"
- Next in thread: Wayne Snyder: "Re: Simple Bulk Insert"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
