Ms access export oracle, need help with this one

Asked By Eleni Hughes 30 points N/A Posted on - 02/03/2013

Hi guys. I am creating a database application using vb6. I need your help on this, I am using ms access as database. How can ms access export oracle database? Thanks in advance guys. 

• Status: Open
• Question Views: 744
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Cathyy Freeman

Go To Solution

Best Answer

Best Answer

Answered By Cathyy Freeman 0 points N/A #198069

Ms access export oracle, need help with this one

 

You should use programs to convert from Ms Excel to oracle database:

The 1-First program is Excel Oracle Import, Export & Convert Software that Use MS Excel as a front-end interface to an Oracle database. Use Excel to import and export tables to and from an Oracle database. Read and write tables to and from Excel without SQL knowledge. Excel 2000 or higher required.

To download it:http://excel-oracle-import-export-convert-softw.software.informer.com/download/

 

2-second program is OraLoader: With OraLoader, you will finally have the power to move data smoothly. OraLoader is a data conversion tool that helps DBA and database developers import/export Oracle databases to or from flat files and Excel files. Features: Import from both flat files and Excel files. Export to multiple formats (text, csv, excel, html, xml, SQL*Loader control file).

To download it : http://oraloader.software.informer.com/download/

Then you should take the file you converted to Vb6 and import it.

About Cathyy Freeman

Questions
1

Answers
16

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 02/26/2013
• Question Category: MS Access

Answered By Gillam Janetj 0 points N/A #198070

Ms access export oracle, need help with this one

 

Hey,

You can set up linked tables in MS Access which 'point' to the actual Oracle data than copying it. That will be a way the data is always up to date.

Or, you need to create a scheduled process, or maybe you need to perform the import via VBA code each and every time the MS Access database opened.

I hope this will solve your issue.

Thanks & Regards

Gillam Janetj

 

About Gillam Janetj

Questions
1

Answers
105

Best Answers
42

• Vote Up 0 Vote Down

• Posted on - 02/27/2013
• Question Category: MS Access

Answered By Edmund Barton 0 points N/A #198068

Ms access export oracle, need help with this one

Hello Eleni,

By using VB6, to make a database application not an easy one i must say. You just have to go through some process to your goal. In MS Access, make a "Marco" to dump the data from a table then make sure a task scheduler is running and put the marco in it. 

Start > Program > Mircosoft > Access > Open existing database > Marcos > new

Hope, it's helpful for you.

Regards.

About Edmund Barton

Questions
2

Answers
26

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 03/09/2013
• Question Category: MS Access