dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Import and Export data from different file format

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Smile Import and Export data from different file format

    Hello Everyone,
    I want to export data into different data file format such as csv, txt, xls etc in MS-SQL Server. So I want to Know whether any option in sql server to resolve this problem.
    Please resolve my problem as soon as possible.

    Thanks in advance!

  2. #2
    Join Date
    Dec 2011
    Posts
    5
    I want to export data into different data file format such as csv, txt, xls etc in MS-SQL Server. So I want to Know whether any option in sql server to resolve this problem.
    Please resolve my problem as soon as possible.

  3. #3
    Join Date
    Oct 2008
    Posts
    142

    dts or ssis

    hi there,

    if you are using sql server 2000 then you can resource to make a dts package.
    if it is 2005 and newer then you can use a ssis package.
    these packages have a wizard, which might make your task simple and fast.
    sometimes, you need to do some dts or ssis programming though.
    you will need bids (business intelligence development studio) if you need some programming for your ssis packages.
    you don't need bids for sql server 2000.

    good luck,

    tonci.

Similar Threads

  1. Replies: 0
    Last Post: 12-20-2009, 08:46 PM
  2. Import XML file into MS Access Table
    By barrett236 in forum .NET
    Replies: 0
    Last Post: 03-30-2005, 10:51 AM
  3. Products which import, export and transform data?
    By TomasSands in forum Database
    Replies: 2
    Last Post: 06-27-2001, 09:26 AM
  4. Replies: 0
    Last Post: 06-19-2001, 09:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center