Good Morning Sally,
After some overnight deep thinks there is a way where
the processing of the files could be automated from
Access.
It requires the use of the Timer on a new Form
dedicated to searching for updates. The Form can
based on new table, tUpdates, containig all updates
that have been processed.
The folder for the UpdateFiles could be in a
subfolder from the database folder say so that you
could use,
strUpdate = CurrentProject.Path & "\Updates\*.txt"
to access the files easily from the Db. When a file
is processed then the filetype could be changed so
that it is no longer recognized when using the
Dir_Function. I don't like the idea of deleting them
automatically just yet.
The sending of emails or files toi the originator
could be done as part of the process.
Hope that gives you food for thought.
Regards, Clive
--- In MS_Access_Professionals@yahoogroups.com, Sally Vega <sally_vega@...> wrote:
>
> Good morning all-
>
> My Boss has requested something that I'm not sure can be done in Excel or Access "automatically".
>
>
> 1.) Is there a way to put an Excel Spreadsheet in a folder and have either Excel or Access import it into Access using a timer. Say every hour?
>
>
> 2.) After it imports the spreadsheet, it needs to be run through a program to validate the data and also check against duplicates both in the imported spreadsheet and in the database. It needs to be able to update the line items that do pass validation and separate those that don't pass validation.
>
>
>
> 3.) It needs to either send an email or maybe put the error in a file somewhere for the user to be notified of the line items that didn't that didn't upload.
>
>
> I have the three steps programmed so that the users upload the file themselves using the import wizard and does the validation/rejection/upload with a few clicks of a button but I don't know that it can be done "automatically". (I hate that word.)
>
> Has anyone ever done anything like this? Any ideas would be greatly appreciated.
>
> Thank you,
>
> Sally Vega
> Supply Chain Data Analyst
> Super First Class Products
> B/E Aerospace, Inc.
> 1851 S. Pantano Rd.
> Tucson, AZ 85710 USA
> (520) 239-4812
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar