Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Import/Export Data

1 view
Skip to first unread message

Marco Tibolla

unread,
Jul 30, 2001, 11:58:45 AM7/30/01
to
Excuse for my English
I need import/export more record from/To my Database (20.000, 30.000
ecord ).
When i import the record from a text file in my DB I dont'have a empty table
so i must update some record and insert some record. I can Use BCP utility
or it is only for Import data. If I can't use BCP what i can doing ?
Tank
Marco


Erland Sommarskog

unread,
Jul 30, 2001, 6:10:55 PM7/30/01
to
[posted and mailed, per favore rispondere in news]

You can use BCP. :-)

I would load the data into a transient table, and the perform the update
from there.

--
Erland Sommarskog, Abaris AB
som...@algonet.se
SQL Server MVP

0 new messages