i will be receiving a fixed width or a comma separated file from my vendors. they will match the columns in my table. I am using Visual Basic (2008) to match the vendors freight bills against the shipping table. so I want to append the file i will receive everyday to the freight bill table when my user selects the vendor and clicks a button. so how do I make this happen? Would it be best to write a stored procedure and call that in my code or figure out how to write the code needed to append the daily vendor files to my db table?