CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 24th, 2004, 03:26 AM #1
    kristine2002
    kristine2002 is offline Member
    Join Date
    Oct 2002
    Location
    asian
    Posts
    116

    Export data to text file

    Does anyone knows how to export data from SQL to a text file and excel?
    I really need you help badly.
    Thanks!!!
    Kristine
    Reply With Quote Reply With Quote
  2. August 24th, 2004, 08:56 AM #2
    tungdt
    tungdt is offline Junior Member
    Join Date
    May 2004
    Location
    C/C++,Java,VB.net
    Posts
    23
    If you use Crystal Report, I will be very easy to export to Excel files...
    If I am on the wrong way, Please give me an outspoken criticism.

    Fortune favours the bold.
    Reply With Quote Reply With Quote
  3. August 24th, 2004, 06:20 PM #3
    soumya_bhatta
    soumya_bhatta is offline Member
    Join Date
    Feb 2002
    Location
    Atlanta, Georgia, USA
    Posts
    155

    Re: Export data to text file

    When you say "from SQL " do you mean from an SQL server database or from a .Net DataSet that you have populated from an SQL command?

    For the first case, I think SQL server DTS export task has options of exporting tables to both excel and text formats.

    For the second case, you can save the dataset as an XML file by using GetXML() on the DataSet and doing whatever you want on the resulting XML file.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured