[AccessD] Update schedule table with new dates

In addition to Charlotte's questions:

How do you differentiate between changed and new schedule items?


On 10 Oct 2011 at 12:36, Keith wrote:

> Hi all.
> 
> I posted this message to Access-L this morning with no response, so I
> was wondering if anyone here could help me.
> 
> I have a need to develop a process (or modify an existing) to update a
> table. Let's say I have tblSched with fields like: strStoreNum,
> strLocation, dteBidDate, dtePossessionDate, dteOpenDate.
> 
> Each week my users update a new Excel schedule sheet and put it in a
> common network directory. I need to develop or find a function that
> will go out to the network folder import the Excel file into a new
> table, and update the tblSched with any CHANGED dates from the newly
> imported table. (Or I could just do a compare to the Excel sheet
> without importing, if that works better.)
> 
> I also need to add any new stores to the tblSched that are included in
> the new Excel sheet that were not in the table prior to the update.
> 
> I am just preliminarily assuming that this will involve Append and
> Update queries, or looping through individual records/fields in the
> two tables.
> 
> Are there any functions out there that will come close to doing what I
> am try to do?
> 
> Thanks.
> Keith
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>