MySQL Forums
Forum List  »  Microsoft Access

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

Options: ReplyQuote


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.