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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.