Importing data from Excel to Query

  • Thread starter Thread starter Kaylen
  • Start date Start date
K

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!
 
Kaylen said:
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!
Click to expand...
 
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.
 
Back
Top