Update Query

[rhernand]

I have a table, to which I added three new columns. I need to populate these three columns. The data is in three columns of a linked EXCEL spreadsheet. The table and spreadsheet are joined with other columns. I created an Update Query, but when I put the name of the corresponding column of the spreadsheet, to get the data, in the Update to: , the Update Query just creates another view field. What am I doing wrong?

 

[reclusivemonkey]

Try using the 'Build' tool in your query; it can help with your syntax, which I suspect is your problem.

 

[rhernand]

Great

That did it. I am running my Update Query now.

Thanks