Hi everyone,
I have a small VB program I am doing, however I have run into a problem I can't seem to figure out.
Currently my code reads a file line by and line in a loop and does some processing stuff such as SQL INSERT, however the file I'm reading from has a large portion that is configuration at the top and the data at the bottom.
What I want to be able to do is tell my code that the data to do the SQL INSERTS on starts at this line or better yet starts 3 lines after this line appears ( to allow for the configuration to change in size ).
How could I go about doing this? Note: I originally planned to use BULK INSERT but it did not want to work so I have gone back to a normal INSERT.
Cheers,
Sam