SQL Server Performance Forum – Threads Archive
Import Data From CSV to MSDE
HiI 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
from Microsoft
http://support.microsoft.com/?kbid=250616
quote:Originally posted by johnsanthosh
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
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
There is a tool for MSDE called MSDE Manager
http://www.valesoftware.com/index.php
]]>