Hi there,
i was wondering if anyone could help me to do this.
I have a text file which is outputted from a legacy system (which i can't change the layout of)
it's in the format
00000111 GHGH33 3FJFJHFJFJ
there are about 1000 lines in each extract, what i want to do is import the file a line at a time and post the data in to an SQL table. so that the format would be ;
Emp Id Code 1 Code 2
111 GHGH33 3FJFJHFJFJ
I need to be able to look at each line as I will need to trim the emp id for example.
What would be the easiest way to do this as the file is not strictly CSV is it?
Many Thanks
Mark
