« How can i access metalink.oracle.com ? it says i need a CSI – a support identifier.?
How do you make an executable file in Microsoft Access 2003? »

How to create a table in ms access 2003 using MS Visual Basic 6.0 ?

I’m making a project using visual basic 6.0 and ms access 2003, which requires to create a separate a table in every financial year. I’m using ADO-Connection to connect the database.I need to know how can i create a table (using sql queries) from VB 6.0 codes. Plz Help Me.

Use the execute command of the ADO object.

For example

objConnection.Execute "CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)"

This example assumed you have declared your ADO connection as objConnection, you will have probably called this something else.

This entry was posted on Sunday, November 29th, 2009 at 8:37 pm and is filed under access 2003. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How to create a table in ms access 2003 using MS Visual Basic 6.0 ?”

  1. Freddy Says:
    November 30th, 2009 at 1:45 am

    Use the execute command of the ADO object.

    For example

    objConnection.Execute "CREATE TABLE customer
    (First_Name char(50),
    Last_Name char(50),
    Address char(50),
    City char(50),
    Country char(25),
    Birth_Date date)"

    This example assumed you have declared your ADO connection as objConnection, you will have probably called this something else.
    References :

Leave a Reply