Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text file into Oracle with VB6

Status
Not open for further replies.
chris6user

chris6user

Programmer
Dec 10, 2001
56
0
0
CA
Hi, I have a text file about 3MB, which I have to extract into Oracle within my vb6 application. I also have to check for several values if they exist in other tables then write the data into a table. Right now for a text file of 3MB it takes about 3 hours to complete. Is it normal?
I access db 4 times for each record over the network.
Thanks,

Chris
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
193
strongm
strongm
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
164
strongm
strongm
Ken01
  • Locked
  • Question
I have a program, developed in VB6
Replies
6
Views
163
Ken01
Ken01
gmmastros
  • Locked
  • Question
VB6 Post to webservice with MSXML2 error
Replies
4
Views
277
dilettante
dilettante
sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
107
muaricewayne
muaricewayne

Part and Inventory Search

Sponsor

Back
Top