Read from Text File Into Table?

• rayd8

  Old Hand

  Points: 325

  More actions

  October 10, 2002 at 12:23 pm

  #80033

  A co-worker of mine asked if it is possible to create a query that will read a specific line and tab position in a text file and insert it into a table.

  He says that he knows it is possible with Oracle. Has anyone heard of this? Unfortunately I'm at work and they don't use SQL Server so I can't search Books Online.

  Thanks for any help.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  October 10, 2002 at 12:36 pm

  #438292

  DTS can do this. Bulk Copy can, but you'd probably want to do a DOS find and get the lines you need into a separate table.

  Or load hte whole thing and delete what you don't want.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones