Hello ! I'm getting some .dat files and when i try to open these files with notepad looks like this:
02154 Mike 8594 08/05/2004 66
02155 James 8766 08/05/2004 01
02156 Nick 4874 08/05/2004 85
02157 Jack 8004 08/05/2004 49
i would like to add some of this values in a sql table which i have create and it has 3 Columns [ID,NAME,DATE]
ID NAME DATE
02154 Mike 08/05/2004
02155 James 08/05/2004
02156 Nick 08/05/2004
02157 Jack 08/05/2004
I'm going to use this for a Bulk of .dat files and not only once
so, I'm searching for a automated way to do this
Thanks