blog

Home / DeveloperSection / Blogs / How to Create Table in MS-Access Database Using C# Code?

How to Create Table in MS-Access Database Using C# Code?

Anonymous User30643 10-Apr-2012

Microsoft Access database is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. In this blog I will explain you how to create a table in MS-Access database. Let’s take a look on it.

To create a table in MS-Access database, first of all you’ve an existence database file or you have to create a new database file. After creating the database file; just write the following line of code to create the table in MS-Access database.

Code for MS-Access 2003:
// Creating OLEDB connection string for Ms-Access 2003 database file
            OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= D:\\Arun Singh\\MsAccessFile\\MyDatabase1.mdb; OLE DB Services=-1");
            // Open the connection
            myConnection.Open();
            // Create Oledb command to execute particular query
            OleDbCommand myCommand = new OleDbCommand();
            myCommand.Connection = myConnection;
            // Query to create table with specified data columne
            myCommand.CommandText = "CREATE TABLE tblIdentityTesting([MyIdentityColumn] long, [Name] text)";
            myCommand.ExecuteNonQuery();
            MessageBox.Show("Table Created Successfully");


Code for MS-Access 2007:


// Creating OLEDB connection string for Ms-Access 2007 database file
            OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= D:\\Arun Singh\\MsAccessFile\\MyDatabase.accdb;Persist Security Info=False;");
            // Open the connection
            myConnection.Open();
            // Create Oledb command to execute particular query
            OleDbCommand myCommand = new OleDbCommand();
            myCommand.Connection = myConnection;
            // Query to create table with specified data columne
            myCommand.CommandText = "CREATE TABLE tblIdentityTesting([MyIdentityColumn] long, [Name] text)";
            myCommand.ExecuteNonQuery();
            MessageBox.Show("Table Created Successfully");


This is a brief description about on creating a table in MS-Access database using C# code. I hope this blog will help you in understanding that how to create a table in MS-Access d
atabase using C# code.


Updated 18-Sep-2014
I am a content writter !

Leave Comment

Comments

Liked By