• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • Last Modified:

How to Automatically import a daily Excel file to an Access table as the Excel file is added, then distribute via email.

Hello Experts,

I have been tasked with creating a daily report.  I would like to automate the entire process, if possible.  I'm talking about not touching it at all once it is set up!  If guided, I am fairly comfortable using macros and VBA.

1)  I would like my Access database to automatically import an excel file to tbl1 as the file is published daily to a server folder. The file names are date based (Report100313.xls, Report100413.xls, etc).  

2)  Upon successful import, I would like a cross-tab query I have built to run and export out to an email distribution automatically.   Sidenote: Is there a way to make the crosstab query include subtotals for each row and column?  

4)  Upon successful distribution, I would like the records in tbl1 to be deleted automatically in order to keep a clean database ready to go for the next day's report.

  • 2
1 Solution
Jeffrey CoachmanMIS LiasonCommented:
Please be aware that what you have asked for here amounts to a "Full Project"...

This is a great deal more than a single question requiring a single straightforward "Answer"...

The best way to generate interest in your questions would be to, request that this Q be deleted,
Then post each of the 4 bullets as separate, sequential questions...


Dominator1025Author Commented:
Will do. Thanks Jeff.
Jeffrey CoachmanMIS LiasonCommented:
And just to be clear, everything you have asked for here is fairly basic.
But taken as a whole, sometimes multi-part questions like this sometimes scares off experts because the scope is so broad.

I hope to see you in one of your follow up questions...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now