i have a data file in text format , i want to convert this text file again in to oracle data base file for this i want coding in vb such that to calculte from this byte to that byte should be update in particular field etc. pls help me?
jto
0
Junior Poster in Training
Recommended Answers
Jump to PostHi jto,
I suggest you make a sub that finds the fields depending on the space character since it seems to delimit your data, for this you can use the SPLIT function to return the data elements in an array.
From there you can easily cut out what …
Jump to PostJTO,
Here is a sample project that reads the data you posted and SPLITs it into an array where you then can manipulate the data and later use to store into your database.
Hope this helps
Happy coding
Yomet
Jump to PostHappy New Year to you too JTO,
I have now added the functionality to insert the data into the included Access database. The easiest way for you to insert into another kind of database, i.e. Oracle, MS SQL Server, etc., would be to link those tables into the Acecss …
Jump to Postjto,
From what I can see there are a few problems with your data file. All this comes from the fact that you are using the SPLIT function and this function splits on EVERY SPACE, if two spaces are together it thinks that it has an empty data field …
Jump to PostAnother thing, I would add code to reject any line that has Data(0) = "ACCOUNT_NO" or "----------" this way you will eliminate these lines from the table data.
Ciao
Yomet
All 21 Replies
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
jto
0
Junior Poster in Training
Yomet
1
Junior Poster
royaloba
0
Junior Poster in Training
Yomet
1
Junior Poster
Yomet
1
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.