title: how to create a mdb file from a csv file in python?
body: <p>I have several csv files that I need to transfer over to mdb format. I tried the answer in this post as a starting point:</p>
  
  <p><a href="https://stackoverflow.com/questions/3094537/how-do-you-create-a-mdb-database-file-in-python">How do you create a mdb database file in Python?</a></p>
  
  <p>Source:</p>
  
  <pre><code>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)
  
  
  db.BeginTrans()
  
  db.Execute("CREATE TABLE test (ID Text, numapples Integer)")
  db.Execute("INSERT INTO test VALUES ('ABC', 3)")
  
  db.CommitTrans()
  db.Close()
  </code></pre>
  
  <p>But I received the following errors:</p>
  
  <pre><code>Traceback (most recent call last):
    File "C:\Documents and Settings\rkelly1\Desktop\New Folder (6)\testwrite.py", line 3, in ?
  access = CreateObject('Access.Application')
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 242, in CreateObject
  return _manage(obj, clsid, interface=interface)
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 188, in _manage
  obj = GetBestInterface(obj)
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 112, in GetBestInterface
  interface = getattr(mod, itf_name)
  AttributeError: 'module' object has no attribute '_Application'
  </code></pre>
  
  <p>All I need to do is take a .csv file, and create a database with it in mdb format. I have some experience with sql but not with creating access data base files....</p>
  
  <p>EDIT: </p>
  
  <p>I am not proposing that this is the right solution.... If you have a better one please let me know</p>
  
  <p>EDIT: The first time the script runs after a fresh install of comtypes I get these errors:</p>
  
  <pre><code># Generating comtypes.gen._4AFFC9A0_5F99_101B_AF4E_00AA003F0F07_0_9_0
  # Generating comtypes.gen._2DF8D04C_5BFA_101B_BDE5_00AA0044DE52_0_2_4
  # Generating comtypes.gen._00020430_0000_0000_C000_000000000046_0_2_0
  # Generating comtypes.gen.stdole
  Traceback (most recent call last):
    File "C:\Documents and Settings\rkelly1\Desktop\New Folder (6)\testwrite.py", line 3, in ?
      access = CreateObject('Access.Application')
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 242, in CreateObject
      return _manage(obj, clsid, interface=interface)
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 188, in _manage
      obj = GetBestInterface(obj)
    File "C:\Python24\Lib\site-packages\comtypes\client\__init__.py", line 110, in GetBestInterface
      mod = GetModule(tlib)
    File "C:\Python24\Lib\site-packages\comtypes\client\_generate.py", line 112, in GetModule
      mod = _CreateWrapper(tlib, pathname)
    File "C:\Python24\Lib\site-packages\comtypes\client\_generate.py", line 176, in _CreateWrapper
      generate_module(tlib, ofi, pathname)
    File "C:\Python24\Lib\site-packages\comtypes\tools\tlbparser.py", line 716, in generate_module
      gen.generate_code(items.values(), filename=pathname)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 238, in generate_code
      self.generate_all(items)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 186, in generate_all
      self.generate(item)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 182, in generate
      mth(item)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 689, in ComInterface
      self.generate(itf.get_head())
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 182, in generate
      mth(item)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 710, in ComInterfaceHead
      self.generate(base.get_head())
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 182, in generate
      mth(item)
    File "C:\Python24\Lib\site-packages\comtypes\tools\codegenerator.py", line 616, in External
      comtypes.client.GetModule(ext.tlib)
    File "C:\Python24\Lib\site-packages\comtypes\client\_generate.py", line 112, in GetModule
      mod = _CreateWrapper(tlib, pathname)
    File "C:\Python24\Lib\site-packages\comtypes\client\_generate.py", line 188, in _CreateWrapper
      mod = _my_import(fullname)
    File "C:\Python24\Lib\site-packages\comtypes\client\_generate.py", line 26, in _my_import
      return __import__(fullname, globals(), locals(), ['DUMMY'])
    File "C:\Python24\lib\site-packages\comtypes\gen\_2DF8D04C_5BFA_101B_BDE5_00AA0044DE52_0_2_4.py", line 82
      ( ['retval', 'out'], POINTER(POINTER(IDispatch)), 'ppidisp' )),
  COMMETHOD([dispid(1610743809), 'propget'], HRESULT, 'Creator',
                                                                 ^
  SyntaxError: invalid syntax
  </code></pre>