Skip a column while importing from a data file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Skip a column while importing from a data file

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-05 : 20:27:30

Gururaj writes "Hai,

We have exported MS-SQL7 table to a datafile(text file) using BCP utility. The table(TABLE1) exported contains 3 columns like:

Table Name : TABLE1 (export)

id int
rel varchar
name varchar

Table Name : TABLE2 (import)

id int
name varchar

Now we want to import the datafile to TABLE2. Here its does not contain the column 'rel'

IS it possible to import the datafile skipping the column 'rel' using BCP utility ?

Any help will be appreciated. Please reply ASAP

Thanx in advance.

regards,

Gururaj B.M.
(gururao@hotmail.com)

"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources