Bcp import - how?

I've exported one table using DTS to *.txt file:
"id","name","calories"
{F5F781EF-4270-4D8C-B5E0-A968F45FF771},"Ananas frisch",60
{CA0E96D8-9017-4DDD-BF29-B78D3DC8180D},"Ananas Fruchtnektar",70
{A1777D54-9303-4AF5-A721-250A39BA731C},"Ananas Fruchtsaft",60
{DACC2063-0985-41EB-9A33-B4D8A10F1C79},"Ananas getrocknet",300
{04E462EC-57B1-4882-A8DF-A1EFC1B9C4F3},"Ananas kandiert",250
How can I import this data using bcp? I've tried many combination of
parameters (-q etc.), but the result ist always wrong (that means, I've
imported but fields are filled with no or partial data). Where can I find a
good description of bcp utility with examples (msdn is very poor)?
Thanx in advance,
Adam
Adam Boczek
adam.boczek@.cs-consulting.de
Hi,
Use BULK Insert.
1. I have saved the contents as ccc.txt in drive.
2. Created a table with below script :-
create table zz(id uniqueidentifier,name varchar(30),calories int)
3. Executed the below in query analyzer
BULK INSERT master.dbo.zz
FROM 'c:\ccc.txt'
WITH
(
FIELDTERMINATOR = ','
)
4. select * from zz
id name calories
-- -- --
F5F781EF-4270-4D8C-B5E0-A968F45FF771 "Ananas frisch" 60
CA0E96D8-9017-4DDD-BF29-B78D3DC8180D "Ananas Fruchtnektar" 70
A1777D54-9303-4AF5-A721-250A39BA731C "Ananas Fruchtsaft" 60
DACC2063-0985-41EB-9A33-B4D8A10F1C79 "Ananas getrocknet" 300
04E462EC-57B1-4882-A8DF-A1EFC1B9C4F3 "Ananas kandiert" 250
(5 row(s) affected)
Thanks
Hari
MCDBA
"Adam Boczek" <adam.boczek@.NO_SPAM.cs-consulting.de> wrote in message
news:1086160529.62750@.proxy.ham.cs-consulting.de...
> I've exported one table using DTS to *.txt file:
> "id","name","calories"
> {F5F781EF-4270-4D8C-B5E0-A968F45FF771},"Ananas frisch",60
> {CA0E96D8-9017-4DDD-BF29-B78D3DC8180D},"Ananas Fruchtnektar",70
> {A1777D54-9303-4AF5-A721-250A39BA731C},"Ananas Fruchtsaft",60
> {DACC2063-0985-41EB-9A33-B4D8A10F1C79},"Ananas getrocknet",300
> {04E462EC-57B1-4882-A8DF-A1EFC1B9C4F3},"Ananas kandiert",250
> How can I import this data using bcp? I've tried many combination of
> parameters (-q etc.), but the result ist always wrong (that means, I've
> imported but fields are filled with no or partial data). Where can I find
a
> good description of bcp utility with examples (msdn is very poor)?
> Thanx in advance,
> Adam
> --
> ----
> Adam Boczek
> adam.boczek@.cs-consulting.de
> ----
>