Results 1 to 3 of 3
  1. #1
    Farmguy0688 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    1

    How to handle multiple excel files and run analysis on them

    I am new to this forum and not sure this is the right place to ask this but I'll try anyway.

    what I'm wondering is if access is able to accomplish the following tasks or if there is a better route.

    I'm looking to process multiple excel files and run simple equations on the resulting data. I will be getting the same data layout in all the excel documents.

    I would like to create a database of the excel documents that can easily be sorted and the reports with the processed data from the documents can printed.

    example spreadsheet a - customer name / results from test a / result from test b/ result from test c and so on....
    spreadsheet b - customer name / results from test a............



    i want to be able to sort through the customers and process run the test results thru some equations.
    the test results are actually numbers that come from a testing lab and they send the results back in a spreadsheet format in excel.

    Any recommendations or ideas for this would be greatly appreciated I've used access in the past but its been a while.
    thanks.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Excel files can be easily imported into Access. Joined/Combined and queried for particular information. Here is a good link to look at in setting up RDBMS.

    http://www.deeptraining.com/litwin/d...aseDesign.aspx

  3. #3
    vincent-leeway is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    36
    I think if you can write a custom code using VB or C#, you will be better able to manage and manipulate your excel files.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 10-31-2013, 06:51 AM
  2. Replies: 11
    Last Post: 12-20-2012, 12:30 PM
  3. Replies: 7
    Last Post: 12-09-2012, 06:20 PM
  4. Linking multiple Excel files - PLEASE help!
    By studor63 in forum Import/Export Data
    Replies: 4
    Last Post: 09-11-2012, 01:24 PM
  5. Replies: 4
    Last Post: 06-14-2011, 07:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums