Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CSV file (A2000)

    I have a CSV file I want to import the data.

    Parts of the data must go to table1

    Parts of the data must go to table2

    Can this be automated and which is the preferred method.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CSV file (A2000)

    Assuming your CSV file will be consistent, you can import it into a table (temporarily), then append the necessary records/fields into the desired tables with an Append Query.
    You can automate the process with a Macro or code as needed.

    You could also create a link to the CSV file rather than importing. For me, that choice would depend on the size and frequency of the operation.

    Hope this helps

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CSV file (A2000)

    You can create a link to the .csv file in your Access database.
    Next, create a query based on the linked table that - depending on your situation - creates Table1 or appends records to Table1, using the appropriate fields and criteria.
    Similarly, create a query, also based on the linked table, that creates Table2 or appends records to Table2.
    Now each time you get a new version of the .csv file, put it in the location of the original one, and just run the two queries. This assumes that the structure of the .csv file remains the same.

  4. #4
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CSV file (A2000)

    Thanks for both views.

    This gives me some sound info to get started.

    Hans, I solved the problem regarding the Arrows.

    ThruDate is one day beyond the end of the displayed period

    If you're interested, I'll post it here. Let me know.

Posting Permissions

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