Results 1 to 3 of 3
  1. #1
    cmdteardrops is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2013

    Post Importing from several Excel files to Access.

    I need some help. I have excel files that I update on a daily basis and save on a daily basis with percentages. I need to take the employee information and the percentages from all these files and put them in a database in excel to the daily percentages as well as weekly and monthly averages.

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Dallas TX
    1) You can manually import the Excel data into tables in Access - that's easy.

    2) Once you have the tables in Access, you can add your data to it using a data entry form and not have to mess around with excel files.

    3) You can get pretty much any report you need once it's in Access.

  3. #3
    KathyL is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Everything Dal Jeasis says is correct.

    You may not need to import the percentages or averages into the Access database. Within Access, there are ways you can summarize table data using queries, and you can place calculations in the queries to compute the percentages, totals, and averages. In a relational database, it’s not too often you have to store the results of calculations, because you design the application to just re-calculate.

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

Similar Threads

  1. regarding choking of access while importing excel files
    By ritimajain in forum Import/Export Data
    Replies: 1
    Last Post: 08-12-2013, 02:16 PM
  2. Replies: 10
    Last Post: 12-28-2012, 02:06 PM
  3. Replies: 7
    Last Post: 12-09-2012, 06:20 PM
  4. Replies: 6
    Last Post: 12-03-2012, 08:08 AM
  5. Replies: 1
    Last Post: 02-21-2011, 09:55 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