Importing data from Excel to Query

[Kaylen]

Is there a way to import data from Excel to update a Query? What I did was
have the users export the query to an excel spreadsheetso that the files can
be reviewed by another person. The reviewer did some corrections on the excel
worksheet and now I would like to have a code or a command button that allows
the user or the reviewer to import the corrected excel worksheet to the
existing query, updating only whatever the corrections are, not duplicate all
the files. Is this possible? Any help is appreciated!

 

[AccessKorea]

Is there a way to import data from Excel to update a Query? What I did was
have the users export the query to an excel spreadsheetso that the files can
be reviewed by another person. The reviewer did some corrections on the excel
worksheet and now I would like to have a code or a command button that allows
the user or the reviewer to import the corrected excel worksheet to the
existing query, updating only whatever the corrections are, not duplicate all
the files. Is this possible? Any help is appreciated!

 

[AccessKorea]

You can set an extra field in worksheet for user to mark which record is
changed and you can use query to replace only those data.