troubleshooting Question

Delete table and insert new values.

Avatar of Aiysha
AiyshaFlag for United States of America asked on
SQL* Access
1 Comment1 Solution53 ViewsLast Modified:
How can I make access query to delete all data from a table and then insert new data. I want to do this in the one query.

DELETE FROM FORECAST
INSERT INTO FORECAST ( PROPNUM, RE_ENG_TAG, WELL_NAME, OUTDATE, [Gross Oil], [Gross Gas], [Gross Water] )
SELECT ariesadmin_AC_MONTHLY.PROPNUM, ariesadmin_AC_PROPERTY.RE_ENG_TAG, ariesadmin_AC_PROPERTY.WELL_NAME, ariesadmin_AC_MONTHLY.OUTDATE, ariesadmin_AC_MONTHLY.S370, ariesadmin_AC_MONTHLY.S371, ariesadmin_AC_MONTHLY.S376
FROM ariesadmin_AC_MONTHLY RIGHT JOIN ariesadmin_AC_PROPERTY ON ariesadmin_AC_MONTHLY.PROPNUM = ariesadmin_AC_PROPERTY.PROPNUM;

Thank you.
ASKER CERTIFIED SOLUTION
ste5an
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros