|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd, 2005, 07:21 AM
|
|||
|
|||
converting access database
I have to convert an access database to an oracle database.
Does someone has tips or can someone tell me how to do that? -- Message posted via http://www.accessmonster.com 
|
|
#2
March 23rd, 2005, 01:10 PM
|
|||
|
|||
|
Does Oracle have a "data transform" feature? MS SQL-Server has a "DTS"
(data transform... service) you can use to import the data structure from Access. Are you trying to import data only, or are you looking for a way to import the entire application? -- Good luck Jeff Boyce Access MVP "jon mich via AccessMonster.com" wrote in message news:e438462954294d29a028030e62e69a52@AccessMonste r.com... I have to convert an access database to an oracle database. Does someone has tips or can someone tell me how to do that? -- Message posted via http://www.accessmonster.com
|
|
#3
March 23rd, 2005, 01:49 PM
|
|||
|
|||
|
I just want to import the data from my access database to oracle
-- Message posted via http://www.accessmonster.com
|
|
#4
March 23rd, 2005, 02:43 PM
|
|||
|
|||
|
With SQL Server (and other "targets"), you could create an ODBC datasource
for the target database/catalog and then export your table(s) to the ODBC datasource name. -- Duane Hookom MS Access MVP -- "jon mich via AccessMonster.com" wrote in message news:8bbf34b975094eccbad8eae2c70f2c3a@AccessMonste r.com... I just want to import the data from my access database to oracle -- Message posted via http://www.accessmonster.com
|
|
#5
March 24th, 2005, 12:29 PM
|
|||
|
|||
|
What version of the Oracle database are you using?
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "jon mich via AccessMonster.com" wrote in message news:e438462954294d29a028030e62e69a52@AccessMonste r.com... I have to convert an access database to an oracle database. Does someone has tips or can someone tell me how to do that? -- Message posted via http://www.accessmonster.com
|
|
#6
March 24th, 2005, 01:48 PM
|
|||
|
|||
|
Create a link to the Oracle tables from within the Access db using ODBC.
Create append queries to take data from the Access tables to put in the Oracle tables. -- Good luck Jeff Boyce Access MVP "jon mich via AccessMonster.com" wrote in message news:8bbf34b975094eccbad8eae2c70f2c3a@AccessMonste r.com... I just want to import the data from my access database to oracle -- Message posted via http://www.accessmonster.com
|
|
#7
March 24th, 2005, 02:58 PM
|
|||
|
|||
|
Jeff,
If he is on Oracle 9i database there is an even easier way -- or at least a way that his DBA's would probably be more comfortable with than using ODBC, but he would have to do it on the Oracle side. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Create a link to the Oracle tables from within the Access db using ODBC. Create append queries to take data from the Access tables to put in the Oracle tables. -- Good luck Jeff Boyce Access MVP "jon mich via AccessMonster.com" wrote in message news:8bbf34b975094eccbad8eae2c70f2c3a@AccessMonste r.com... I just want to import the data from my access database to oracle -- Message posted via http://www.accessmonster.com
|
|
#8
March 24th, 2005, 06:00 PM
|
|||
|
|||
|
Lynn
I suspected as much, but couldn't speak knowledgeably -- and I know the "push" could work. Jeff "Lynn Trapp" wrote in message ... Jeff, If he is on Oracle 9i database there is an even easier way -- or at least a way that his DBA's would probably be more comfortable with than using ODBC, but he would have to do it on the Oracle side. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Create a link to the Oracle tables from within the Access db using ODBC. Create append queries to take data from the Access tables to put in the Oracle tables. -- Good luck Jeff Boyce Access MVP "jon mich via AccessMonster.com" wrote in message news:8bbf34b975094eccbad8eae2c70f2c3a@AccessMonste r.com... I just want to import the data from my access database to oracle -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
| Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
| Exclusive access to the database | Steve Huff | General Discussion | 17 | December 24th, 2004 06:23 PM |
| You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Linear Mode
