Xcopy

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ashokgundla
    New Member
    • May 2007
    • 1

    #1

    Xcopy

    Hi

    I want to read .txt file and save that txt file to database
    by using XCOPY, can u pls sugest
  • rharvieuxsql
    New Member
    • Nov 2006
    • 9

    #2
    --Try using BULK INSERT:

    CREATE TABLE SomeTable (Results varchar(1000) null)
    BULK INSERT YourDatabase.db o.[SomeTable]
    FROM 'd:\yourfile.tx t'

    --Or try using TYPE:

    CREATE TABLE SomeTable (Results varchar(1000) null)
    INSERT INTO SomeTable(Resul ts)
    exec ('master..xp_cm dshell ''type d:\yourfile.txt ''')

    Comment

    Working...