C#

/// <summary>
/// Constructs the required SQL Query to create the tables in mdb database and then executes the query.
/// </summary>
private void CreateTables()
{
    string sqlCommand = "CREATE TABLE ";
    foreach (DataTable dTable in currentDataSet.Tables)
    {
        string sqlCreate = sqlCommand + dTable.TableName + "(";
        int cnt = 0;
        foreach (DataColumn dColumn in dTable.Columns)
        {
            string sqlCreateCommand = sqlCreate + dColumn.ColumnName;
            if (cnt != dTable.Columns.Count - 1)
            {
                cnt++;
                sqlCreateCommand += GetDataType(dColumn) + ", ";
            }

            if (dTable.Columns.IndexOf(dColumn) == dTable.Columns.Count - 1)
            {
                cnt++;
                sqlCreateCommand += GetDataType(dColumn) + ");";
            }
            sqlCreate = sqlCreateCommand;
        }


        OleDbCommand dbCommand = new OleDbCommand(sqlCreate, (OleDbConnection)dsConnection.CurrentDbConnection);
        dbCommand.ExecuteNonQuery();
    }