Post reply

Link txt files..;

  • June 17, 2007 at 11:46 pm

    #124499

    Hi,

    Is there a way to link to SQL Server txt files; If so can you describe me the way to do it;

     

    Thank you.

  • June 18, 2007 at 1:51 am

    #713502

    When you mean to say link to sql server txt files. Do you mean this.

    Read the contents of the file from a text file and write to to SQL Server database. Or read the SQL server database and write to a txt file.

    If you would have meant this then the answer is use OPENDATASOURCE to do the same if its going to be a 1 time activity. Else yo can create a linked using an ODBC and use that as a permanent connection.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 18, 2007 at 2:12 am

    #713505

    Thanks for your reply

    Well actually it is the first one. I export from Sap some tables to txt format. I want to read the contents of the txt files and write to SQL. I don't want to import them with the import wizard.

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

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