#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    2
    Rep Power
    0

    Question visual basic 2012


    hello guys iam new member here

    i get a problem with insert into access 2013

    how i insert into access ??

    i wish to have answer here


    thanks guys for help
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    289
    Rep Power
    44
    You simply create an SQL statement:
    "INSERT INTO " & TableName & "(" _
    & FieldList & ") VALUES(" & ValueList & ");"
    and execute it. There are literally hundreds upon hundreds of examples on the internet.

    J.A. Coutts
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    2
    Rep Power
    0
    ok if i dont want sql ??

    what the code for insert ??

    becouse my project with out sql

    please help me
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    289
    Rep Power
    44
    SQL stands for Structured Query Language, and is used by many different database engines including Access. It is not limited to MS SQL Server. If you have Access 2013, then you are already using SQL whenever you create a query. Once you create a query, there is a menu option to view the SQL statement that performs the query that you just created. I often create the query in Access, then copy and modify the SQL statement that it provides. It is by far the simplest way to do what you are asking, to the extent that I cannot even advise you on other ways.

    J.A. Coutts

IMN logo majestic logo threadwatch logo seochat tools logo