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 CSV to MSDE

Author  Topic 

johnsanthosh_t
Starting Member

1 Post

Posted - 2005-04-25 : 02:20:41
Hi
I am new to Ms-sql.
I have installed MSDE 2000. I have doownloaded and installed.
and gettinhg into visual studio.net. I have created a database with some tables.
and now i have a CSV file. I have to import data from the csv file to Msde tables.
but I dont have any options to import. and also how to DTS .
i DONT FIND DTS option anywhere.
ppls help nme to do that.

john

nr
SQLTeam MVY

12543 Posts

Posted - 2005-04-27 : 16:03:10
see
see
http://www.mindsdoor.net/SQLTsql/ImportTextFiles.html
and
http://www.mindsdoor.net/SQLTsql/f_GetEntryDelimiitted.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -