求如何在python中创建access数据库

[Geek青松]

不是创建库中的表，是创建数据库？求大神指教

[人傻且呆但不萌]

how about this one ?:

from comtypes.client import CreateObject

access = CreateObject('Access.Application')

from comtypes.gen import Access

DBEngine = access.DBEngine
db = DBEngine.CreateDatabase('test.mdb', Access.DB_LANG_GENERAL)
      # For me, test.mdb was created in my My Documents folder when I ran the script 

db.BeginTrans()

db.Execute("CREATE TABLE test (ID Text, numapples Integer)")
db.Execute("INSERT INTO test VALUES ('ABC', 3)")

db.CommitTrans()
db.Close()

and refer this link :http://stackoverflow.com/questions/3094537/how-do-you-create-a-mdb-database-file-in-python

[Geek青松]

还是google强大，已经实现了：（需要pypyodbc库支持）

def database_create(table_num):#若数据库文件不存在，则创建access数据库文件以及whois表
    try:
        if os.path.exists(r'**.mdb') == False:#检查是否存在数据库文件
            pypyodbc.win_create_mdb('**.mdb')#创建access数据库
            conn = pypyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};PWD=thepwd;DBQ= **.mdb')#连接数据库
            cur = conn.cursor() 
            for i in range(table_num):           
                cur.execute('''CREATE TABLE ''' + str(i + 1) + '''(ID COUNTER PRIMARY KEY,ip_scale VARCHAR(50), 
                            netname VARCHAR(50), admin VARCHAR(50),techVARCHAR(50));''')#创建whois表
                cur.commit()
            conn.close()            
    except Exception, e:
        traceback.print_exc()
        os._exit(0)