Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #16434

Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!cs.uu.nl!news.stack.nl!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path <miki.tebeka@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.087
X-Spam-Evidence '*H*': 0.83; '*S*': 0.01; 'reply- to:addr:comp.lang.python': 0.09; 'to:addr:comp.lang.python': 0.09; 'from:addr:miki.tebeka': 0.16; 'from:name:miki tebeka': 0.16; 'subject:Converting': 0.16; 'subject:ORM': 0.16; 'win32com': 0.16; 'cc:addr:python-list': 0.16; 'header:In-Reply-To:1': 0.22; 'cc:2**0': 0.24; 'cc:addr:python.org': 0.29; 'example': 0.29; 'subject:support': 0.30; 'header:User-Agent:1': 0.33; 'url:python': 0.36; 'subject:with': 0.36; 'url:pipermail': 0.37; 'received:google.com': 0.37; 'using': 0.38; 'received:209.85': 0.38; 'url:org': 0.39; 'received:209': 0.40; 'header:Reply-To:1': 0.71; 'reply-to:no real name:2**0': 0.72; 'reply- to:addr:googlegroups.com': 0.74; 'received:209.85.213.184': 0.84; 'received:mail-yx0-f184.google.com': 0.84; 'subject:Access': 0.84
Newsgroups comp.lang.python
Date Wed, 30 Nov 2011 06:55:10 -0800 (PST)
In-Reply-To <mailman.3142.1322628573.27778.python-list@python.org>
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=75.84.253.172; posting-account=uo-8fwoAAACKsFzFX78JHudx1V7WDXZ0
References <mailman.3142.1322628573.27778.python-list@python.org>
User-Agent G2/1.0
X-Google-Web-Client true
MIME-Version 1.0
Subject Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy
From Miki Tebeka <miki.tebeka@gmail.com>
To comp.lang.python@googlegroups.com
Content-Type text/plain; charset=ISO-8859-1
Cc "comp.lang.python" <python-list@python.org>
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.12
Precedence list
Reply-To comp.lang.python@googlegroups.com
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Message-ID <mailman.3159.1322664913.27778.python-list@python.org> (permalink)
Lines 3
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1322664913 news.xs4all.nl 6945 [2001:888:2000:d::a6]:43482
X-Complaints-To abuse@xs4all.nl
Xref x330-a1.tempe.blueboxinc.net comp.lang.python:16434

Show key headers only | View raw


You can read data using win32com (ADODB?) and then write it to the desired database using the right package (psycopg2 ...).

See example for reading data at http://mail.python.org/pipermail/python-win32/2006-March/004420.html

Back to comp.lang.python | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Alec Taylor <alec.taylor6@gmail.com> - 2011-11-30 15:49 +1100
  Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Miki Tebeka <miki.tebeka@gmail.com> - 2011-11-30 06:55 -0800
  Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Miki Tebeka <miki.tebeka@gmail.com> - 2011-11-30 06:55 -0800

csiph-web