update date in table from query

Q

Qaspec

I have a table "tblTemp" that I would like to update with information pulled
from a query "qryEscData". Originally "qryEscData" was a maketable query
(that created tblTemp) and I would like to turn it into a query that will
always update the table with current data whenever the query is run. When I
try to turn "qryEscData" into an update query I get an error message that
states "Query must be updateable" or something to that effect. "qryEscData"
is running off a union query ("qryConsolidate") that runs from multiple
linked excel files/tables. I need to make it so that when users change the
data in their excel file the data in" tblTemp" changes to reflect the data in
the excel files. Your help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Add additional information to excel form after original data entry 0
Creating a Chart on form from selected data in query. 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Update Query 2

Top