[AccessD] Update schedule table with new dates

Keith okiearcher at gmail.com
Mon Oct 10 12:36:08 CDT 2011


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




More information about the AccessD mailing list