View Full Version : Import / Query Problem


Yecats131
04-24-2008, 11:30 AM
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
04-24-2008, 11:41 AM
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
04-24-2008, 11:59 AM
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
04-25-2008, 08:17 AM
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.