37,743
社区成员




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)
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