INSERT INTO query

  • Thread starter Thread starter Jac Tremblay
  • Start date Start date
J

Jac Tremblay

Hi,
In Access 2007, how can one create such a query? The option is not available
with the wizard either.
Thanks.
 
Hi,
In Access 2007, how can one create such a query? The option is not available
with the wizard either.
Thanks.
Click to expand...

Try using the keyword APPEND instead of INSERT.
 
Hi John,
You are right. It works OK. But it seems to me that there are fewer options
in the 2007 version than in the 2003 for the type of query one can use.
Those options are useful when one wants to find out the right syntax for a
particular SQL query.
Thank you for your answer.
 
Hi John,
You are right. It works OK. But it seems to me that there are fewer options
in the 2007 version than in the 2003 for the type of query one can use.
Click to expand...

I don't think that any query types have been removed, but they may well be
harder to find! One of several reasons I've held off on installing 2007.
 
Hi John,
After some time with the 2007 version, I'm starting to appreciate it more
and more every day. The learning curve is quite steep, particularly for
beginners I suppose.
Myself, I had very good reasons to switch to a Professional english version
of Office and I'm glad I did it.
Thanks for your comments. I appreciate.
 
Hello..... I am totally lost on how to use database.... how do i get to the
design wizard so I can do a query? And what does primary key mean? Thank you
 
Hi Jackie,
If a database means nothing to you as well as a primary key or the design
wizard, why are you in the Microsoft Access programming discussion group? You
should take a course (at least 3 months) on databases and systems
architecture. Look for database for beginners on MSDN or Google.
Unfortunately, I cannot give you links to start with but someone else will
surely do that for you since people in this group are very friendly and
helpful.
I wish you courage and good luck.
And please, do not hesitate to post questions again and try to be clear so
answers are easier to formulate.
 
Hello..... I am totally lost on how to use database.... how do i get to the
design wizard so I can do a query? And what does primary key mean? Thank you
Click to expand...

You might want to post a New message - probably in the Getting Started group -
rather than replying to an existing message in the much more advanced Modules,
DAO, VBA group.

For some tutorials see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top