473,322 Members | 1,379 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,322 software developers and data experts.

ODMC Table Export to Oracle

I am able to export an MS-Access table to Oracle if that table does
not exist there. I would like to append data to the Oracle table, but
I get the Oracle message "Error--00955 Name is already used by an
existing object."
Is it possible to use MS Access Table Export to append to an
existing Oracle table?
thanks, tom g
Nov 13 '05 #1
1 1866
tomg wrote:
I am able to export an MS-Access table to Oracle if that table does
not exist there. I would like to append data to the Oracle table, but
I get the Oracle message "Error--00955 Name is already used by an
existing object."
Is it possible to use MS Access Table Export to append to an
existing Oracle table?


Why not just link the Oracle table to the Access front-end & append
records using Access queries?

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: valexena | last post by:
In which table is Oracle database audit information stored? -- Posted via http://dbforums.com
2
by: google_user | last post by:
Hi, I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT and RESOURCE privileges granted. All this needs to be...
2
by: narasingarao | last post by:
Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting...
5
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because...
0
by: quiquef | last post by:
Hi, I am sending emails to students using PL/SQL. My problem is: if the student wants to unsubscribe from the mailing list. How can I load that into a table using Oracle PL/SQL.
5
kiss07
by: kiss07 | last post by:
Hi deba, What is the usage of dual table in oracle?Use any applications? what is difference between decode and if-the -else(any restrictions)between two:? pls explain.. ARUN..
5
by: Naveen Kumar Srivastava | last post by:
Hi to All I want to create a table in oracle having name more than 16 character how i can? I know that oracle support table namt upto 28 character by default it support 15 character but i don't...
6
by: ghjk | last post by:
I want to export oracle(version 9.2.0.1) database to a flat file. How can I do that? Is there any free tools for that? Found a tool called data loader but it is a commercial one.
2
by: Zeeshan Akbar | last post by:
I want to create a table on Oracle on a click event of a button on ASP.NET. My webpage need a dynamic structure of table creation on the back-end (which I have connected with Oracle...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.