How to create "Insert" query for user input in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I want to have an "insert" query that accepts user input and inserts a new
row to the table. However I don't see there's one such type of query
available in access as it is available in MS Sql server. Am I missing
anything or how do you do "insert" normally?

By the way, I am writing a c# application that use access as its underlying
database and I want to create querys for the most common database operations
such as "select", "update", "delete" and "insert".

Thanks for any helps!
 
There is an "INSERT INTO ..." SQL construct.

Check the JET SQL Reference section of Access Help.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top