Importing ASCII files

  • Suppose I had 10 ASCII-text files in a directory named A.txt, B.txt, C.txt, etc. All these files needed to be imported into SQL, what is the quickiest way? Due to time contraints I had to individually import all 10 through DTS....there has to be a better way. If all of these files were individual tables in an Access database then they all could have been imported through a single DTS process.

  • Maybe of relevance.

    See http://www.sqldts.com/?246

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

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