Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Directly run insert statements

Hi,

In Access 2013, how to directly execute insert/delete statements against the tables?
0
HuaMinChen
Asked:
HuaMinChen
1 Solution
 
sarabandeCommented:
in access 2010 you would create a new query, skip the selection of a table. then a button 'SQL' would appear in the ribbon bar which would give a command window where you can type sql statements.

Sara
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You can also execute SQL statements in code directly by doing:

CurrentDB().Execute <SQL Statement>, dbFailOnError

There is also a series of articles starting with this one:

Fundamental Microsoft Jet SQL for Access 2000
http://msdn.microsoft.com/en-us/library/office/aa140011(v=office.10).aspx

That walk you through all the SQL that can be used with Access and JET.

Links to part 2 and 3 of the series is at the bottom of the page.

Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now