Post reply

How to export data into text file by using SQL 2005 Express?

  • March 5, 2007 at 10:36 am

    #176209

    To read a text or cvs file, I use

    select * from OpenRowset('MSDASQL', 

      'Driver={Microsoft Text Driver 

      (*.txt; *.csv)};

      DefaultDir=C:\External;',

      'select top 5 * from

    Serverlist1.txt')

     

    I tried the same command for exporting like this

    Insert into OpenRowset('MSDASQL', 

      'Driver={Microsoft Text Driver 

      (*.txt; *.csv)};

      DefaultDir=C:\External;',

      'select top 5 * from

    Serverlist1.txt') select * from table1

     

    I get this message and need your help

    Msg 7390, Level 16, State 2, Line 2

    The requested operation could not be performed because OLE DB provider "MSDASQL" for linked server "(null)" does not support the required transaction interface.

    Thank you.

  • March 5, 2007 at 10:54 pm

    #693245

    Try using bcp utility...

    Check BOL for syntax...

    MohammedU
    Microsoft SQL Server MVP

  • March 6, 2007 at 9:18 am

    #693347

    I have tried using BCP utility, but it's not working properly.  I always received a message of "Name pipes not able to reach", but I have enabled pipenames.

    Minh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply