Post reply

Import txt data file into temp table

  • 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.

  • 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

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

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