MYSQL -> Access (update query)

[chelm]

I'm new to access and I'm trying to learn the functionality by creating a relational DB for US zip codes from an excel document. I've imported everything and I have the tables setup. Is there a way to run a MYSQL query like this:

UPDATE tbllocation, tblzipcode SET tbllocation.ZipID = tblzipcode.ZipID WHERE tbllocation.ZipID = tblzipcode.ZipCode;

in access 2007?

Thanks

 

[KeithG]

try the below

Update tblLoaction InnerJoin tblZipCode on tbllocation.ZipID=tblZipCode.zipcode Set tblLocation.ZipID=tblZipCode.ZipCode

 

[chelm]

I did get it to work, just a couple small syntax errors, THANKS!

UPDATE tbllocation INNER JOIN tblzipcode ON tbllocation.ZipID=tblzipcode.ZipCode SET tbllocation.ZipID = tblzipcode.ZipID;