Thanks.
I solved this now. The first argument in CopyObject should simply be the
file path to the database being accessed.
Internet
m...@timgolden.me.uk
29/07/2009 09:23
To
Sebastian VENUS, python-win32@python.org
cc
Subject
Re: [python-win32] Copying a MS Access Table
[copying back
Sebastian:
You have what looks (to a non-Postgres user) like a proper ADO connection
string for PostgreSQL. Open the Postgres database using adodbapi. I have
already done all of the tricky COM stuff for you. You can also open the
ACCESS database using adodbapi. There is an example in C:\python{y
Tim Golden wrote:
[copying
back to the list]
Not sure how to reply to the thread, since I thought that if I reply
to "python-win32@python.org" then it would start a new thread?
Replying to python-win32@python.org is the right thing to
do; the mailing list software should recognise all the
c
Are you trying to copy a table from an access database to a postgres
database? Because that's the impression I get, in which case do you
need to do it once or do you need to do it regularly? In both cases
Python might not be an optimal choice.
You might have more luck using TransferDatabase and ODB
[copying back to the list]
Not sure how to reply to the thread, since I thought that if I reply to
"python-win32@python.org" then it would start a new thread?
Replying to python-win32@python.org is the right thing to
do; the mailing list software should recognise all the
clues it needs to con
sebastian.ve...@uk.bnpparibas.com wrote:
Hi, how can I make a copy of a table in an Access database using Python?
The VBA command would be 'DoCmd.CopyObject'. If there is no such command
for Python, then alternatively I could request Python to call a VBA
function that does that, but I don't kno
Hi, how can I make a copy of a table in an Access database using Python?
The VBA command would be 'DoCmd.CopyObject'. If there is no such command
for Python, then alternatively I could request Python to call a VBA
function that does that, but I don't know how to do that either.
Many thanks for yo
