trying to load a text files into 2 mssql tables. the text file contains rows of record where if it starts with H (header) will go to tab1 & if it starts with numeric will go to tab2.
example of the text file are like this
and i have to import into below table
the text file have fix char location & i have to extract it out to put into specific col.
anyone have any ideas how to do this or done it b4 ? thanks