[AccessD] Update schedule table with new dates

If by a "function" you mean something built in, no.  If you want code to do
it, that may be doable, but you need to tell us what version of Access
you're using and what exactly you are trying to accomplish in more detail.

It sounds like you have mutliple users entering data into an Excel workbook,
but is it a shared workbook or multiple workbooks?  Does it have a single
worksheet or multiples, i.e., one for each user, or what?  What data field
or fields are you keying off of on the spreadsheet, and what kind of keys do
you have in the Access tables.   What do you want to do with the data once
it's in Access?  That determines data structures and a bunch of other
things.

Fill in the blanks, and someone may be able to help.

Charlotte Foust

On Mon, Oct 10, 2011 at 10:36 AM, Keith <okiearcher at gmail.com> 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<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>