Import / Query Problem

[Yecats131]

Hello!

I originally posted this in the general forum because I did not know where to begin with my problem.

(Link: http://www.access-programmers.co.uk/forums/showthread.php?t=148131 )

According to the person who responded, I need to create an update query. How do I do that?

Thanks!

 

[boblarson]

Not sure what version of Access you are using but here's a tutorial on Queries

http://www.functionx.com/access/Lesson26.htm

that is really good. The update queries are dealt with further down in the page.

 

[Yecats131]

I'm working with Access 2007. Thanks for the tutorial! I'll take a look at this and let you know if I have any more questions.

:0)

 

[Yecats131]

So, is there a way to have an Update Query update based off of a spreadsheeT?

The tutorial seems to indicate that you can only do an Update __ with ___ if X condition is met.