Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Cool Unanswered: Multiple INSERT within an Access Query

    using a CSV file with 220 fields on each row i'm trying to write a single query which will, for each row, create multiple records on the same access table.

    Example:
    The table in question (tblParts) has 2 fields:
    Code
    Description

    One row on the CSV File has looks like this:
    BRK,Brakes,CAM,Cambelt,BAT,Battery

    From the example row of the CSV, the query should create 3 records in tblParts.

    record1 :
    Code="BRK"
    Description="Brakes"

    and so on..................


    Any Ideas how to go about this?

  2. #2
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Multiple INSERT within an Access Query

    Originally posted by Towquest
    using a CSV file with 220 fields on each row i'm trying to write a single query which will, for each row, create multiple records on the same access table.

    Example:
    The table in question (tblParts) has 2 fields:
    Code
    Description

    One row on the CSV File has looks like this:
    BRK,Brakes,CAM,Cambelt,BAT,Battery

    From the example row of the CSV, the query should create 3 records in tblParts.

    record1 :
    Code="BRK"
    Description="Brakes"

    and so on..................


    Any Ideas how to go about this?

    See attached files. Simple copy the files to c:\temp and run the form.

    Hope that this works.

    Cheers
    Attached Files Attached Files
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

  3. #3
    Join Date
    Mar 2003
    Posts
    4

    Thumbs up

    Cheers Mona
    You're a star and no mistake

  4. #4
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173
    Originally posted by Towquest
    Cheers Mona
    You're a star and no mistake
    You're welcome
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •