Home > IT Answers > Oracle > I want small application, any one can help me?
Muraliavn
5 pts.
 I want small application, any one can help me?
Oracle 9 Database, Oracle 9i, VB script
I have one excel file it have 3000 records (74 fields for one record). And I have one application Form (developed in VB). This program back end Orcale 9i. Now, I want copy text from excel sheet to that form. I do it manually it's take 4 minutes for one record. But I want now, one application for automatically copy text from excel sheet and paste in the Form. my mailid muraliavnprofile@gmail.com

Software/Hardware used:
any software
ASKED: January 18, 2010  1:44 PM
UPDATED: January 22, 2010  6:06 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I would suggest using ADO.NET to read the contents of the sheet inside your program to feed the data directly into the form. Or even better automatically process the data once the app has it.

Here is the MS article on how to do this.

If you not a developer or don’t have access to the original source code I would suggest you use one of the coder for hire services.

Gent01
 1,855 pts.