By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,164 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,164 IT Pros & Developers. It's quick & easy.

DoCmd.TransferDatabase acImport using ODBC

P: 1
Hello!

I have the following problem. I'm trying to use an ODBC connection to import one table from an ORACLE database to my access database.

Manually, trough access command panel database ODBC, I can do it very easily. I use the following information

Oracle OBDC Drive Connect
Machine Data Source: TYPE_FAN
Service Name: RATIO001
User Name: MACKTTP1
Password: syygyat
Access Database Name: NURNMM.accdb
Source Table Name: MAINDATA_UPDATE
Destination Table Name: MAINDATA_UPDATE_TARG

When I try to use the following command I'm always have an error.

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=RATIO001;UID=RATIO001;PWD=syygyat;LANGUA GE=us_english;" _
& "DATABASE=NURNMM.accdb", acTable, "MAINDATA_UPDATE", "MAINDATA_UPDATE_TARG", False, True

Can some one help me?
Jul 3 '13 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,369
What is the error message?

This looks like VBA code. Is it VBA or ASP? Let us know so we can move it to the right forum.
Jul 3 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.