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)
 Import data from a csv file

Author  Topic 

sandeepvan83
Starting Member

1 Post

Posted - 2007-05-07 : 07:53:54
Hi,

I want to import data from a .csv file onto a table.
The constraints are:
1. I don;t want to use bulk insert.
2. I don't want to use DTS packages.
Can anyone suggets any other methods, if there are.

Thanks in advance.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-07 : 07:56:26
How about BCP?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-07 : 08:51:52
or Import/Export wizard?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-07 : 08:56:07
quote:
Originally posted by madhivanan

or Import/Export wizard?

Madhivanan

Failing to plan is Planning to fail



Is that not part of DTS, Madhi?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -