Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012
    Posts
    1

    Unanswered: Excel to Access help needed

    I am new to the idea of transferring data from Excel into a Master data base. I have multiple CSV files that need to be combined into one data base. My questions are with the process and the coding. The CSV files that generate from our tester give about 30 parameters tested. We only want to pull about 10 of these out and put into a database file. How do I go about doing this from Excel to Access? If I need to write a Macro or use Visual Basic I am lost. Please help.

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    from excel to tables in access (if this is going to be an ongoing process- every day or week, etc.)

    Record a macro that selects your data based on the drop down list at the top of a column with your parameters -, export the data or copy the data and paste into access table(s)
    stop recording the macro when all data is placed into the table(s). then save the macro - run it when needed

    that is all IO can tell you now - with out very much information and limited knowledge of the data and rocesses.
    Dale Houston, TX

Posting Permissions

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