Ms access export oracle, need help with this one

Asked By 30 points N/A Posted on -
qa-featured

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. 

SHARE
Best Answer by Cathyy Freeman
Best Answer
Best Answer
Answered By 0 points N/A #198069

Ms access export oracle, need help with this one

qa-featured

 

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.

Answered By 0 points N/A #198070

Ms access export oracle, need help with this one

qa-featured

 

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
 
Answered By 0 points N/A #198068

Ms access export oracle, need help with this one

qa-featured

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.

Related Questions