Import txt data file into temp table

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  September 30, 2014 at 12:44 pm

  #397433

  In Access, I can import a txt file data(e.g. Claims.txt) as below specifications:

  Choose the delimiter that separates your fields: Other (|)

  First row contains field name: Yes

  Text Qualifier:"

  I need to create a store procedure to read txt file data (d:\cliam\cliams.txt) first column (ClaimNumber) into a temp table (#claim)

  (This #claim table will use for my .Net program)

  There about 5 txt files need to process every day.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  September 30, 2014 at 1:21 pm

  #1749247

  If you know the structure of the files and have the tables created, you could use BULK INSERT to import the files.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2