473,394 Members | 1,641 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

DoCmd.TransferDatabase acImport using ODBC

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
1 2669
Rabbit
12,516 Expert Mod 8TB
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

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

Similar topics

2
by: AccessStarters | last post by:
I am trying to Import a simple dbase file into my Ak2 TABLES. If I do this manually, it works fine. I get a new table called DBASE with all the data looking good. If I try and do this using VBA...
1
by: Sven | last post by:
HI all, is there a way to call my own VB Procedure from a .NET Application using ODBC ? I tried different ways like: SELECT myProc() FROM... SELECT { fn myProc()} FROM... SELECT { call...
0
by: astro | last post by:
I'm trying to copy some ODBC linked tables from one access2k mdb to another. This is an example of the code i'm using: DoCmd.TransferDatabase acExport, "Microsoft Access", (strPath & strTemp),...
0
by: Alan White | last post by:
Hello, I need to read the excel file using Odbc, but when I run my code, I got the following error: "Error: ERROR Data source name not found and no default driver specified" Could someone...
2
by: Mahesh.V | last post by:
Hi All I get the following error while connecting to the oracle database using ODBC. in my VB.NET application. Can any one help me out solving this problem server message (if any):...
2
by: Scott M. Lyon | last post by:
I currently am working on a VB.NET application that imports data from an Excel spreadsheet that the customer filled in. I used the following code to use ODBC to read the data from the...
2
by: 111mike | last post by:
Hello, Here's my problem. I cannot connect to mysql database using odbc string connections or dns. I keep getting a "cannot connect to mysql server localhost." I'm running windows XP Pro and...
3
by: Suresh P | last post by:
Hi All, I tried to access the mysql database in ODBC using ip address and username/password. It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This could be related to Firewall...
1
by: amitkumar19 | last post by:
hello dear when i use this statements in vb6 for transfer data to one another DoCmd.TransferDatabase acImport, "dBase III", "C:\Data", acTable, _ "Test112A.dbf", "TempFile" then give a error...
1
by: amitkumar19 | last post by:
hello dear when i use this statements in vb6 for transfer data to one another DoCmd.TransferDatabase acImport, "dBase III", "C:\Data", acTable, _ "Test112A.dbf", "TempFile" then give a error...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.