General discussion

Locked

Data Transfer

By ali.ergelen ·
How i can transfer my MS excels data to Oracle Database.
pls give me sample

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data Transfer

by donq In reply to Data Transfer

Transfer Excel into Access.

Both Access and Oracle are ODBC database products, and once the data is in Access Oracle can open it merely by using the .mdb file as its Data Source.

Getting the data into Access is a seamless request between two Microsoft Products.

Collapse -

Data Transfer

by ali.ergelen In reply to Data Transfer

The question was auto-closed by TechRepublic

Collapse -

Data Transfer

by Mohammad_M_Saggaf In reply to Data Transfer

I faced this problem many times before.
And I usually solve it by using a VB converter form, which is a form that open the two databases (in your case the oracle and exel) using ADO and read the records from one and add it in the second in for loop.
I can't write an example. It's reletivly long. But I hope I helped.

Collapse -

Data Transfer

by ali.ergelen In reply to Data Transfer

The question was auto-closed by TechRepublic

Collapse -

Data Transfer

by ali.ergelen In reply to Data Transfer

This question was auto closed due to inactivity

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums