MySQL Forums
Forum List  »  Microsoft Access

exporting table via odbc - access
Posted by: klaus
Date: August 19, 2005 06:04AM

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

Options: ReplyQuote

Written By
exporting table via odbc - access
August 19, 2005 06:04AM
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.