You could try to import each file into a one column staging table. Then write a select against the table to exclude rows, you will probably need to use LIKE. You may want to delete the junk rows at this point. Then try to parse your data out into columns which will be inserted into a destination table.
For the last step you could post representative sample data here and perhaps get some guidance on how to approach this.
The only additional thought I have is to automate your solution with SSIS which will apply the formatting to each file in a folder, so that you don't have to do this manually.
Hope to see other answers here.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply