exporting table via odbc - access
Posted by:
klaus
Date: August 19, 2005 06:04AM
hello,
as absolutly newbee I'm trying to export and import tables via odbc everytime access starts:
importing is working with this:
DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DATABASE=***;UID=***;PWD=***;DSN=**", acTable, "cia_cim_prices_wels", "cia_cim_prices_wels", False
now I want that an other table gets to the database and I tried this
DoCmd.TransferDatabase acExport, "ODBC", "ODBC;DATABASE=***;UID=***;PWD=***;DSN=**", acTable, "Rechnung", "Rechnung", False
now I get an error message that the table already exists - how can I tell it that it should overwrite the existing table?`!
thanks in advance
klaus
Subject
Views
Written By
Posted
exporting table via odbc - access
5396
August 19, 2005 06:04AM
2132
September 09, 2005 06:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.