Import multiple Excel files to Database
Posted on 2011-02-20
I have a client with a TON of Excel files he has been using for YEARS to create work tickets and invoices. He has hundreds and hundreds. The information is all in certain fields (Example: Date is K12, Invoice Number is K4, Description is D4, etc).
What is the best approach to puling this info into a database? A visual basic script? I want to pull the all in and use the Invoice Number field to distinguish between invoices and work tickets. (Easy enough as all work tickets are labled WORKTICKET).
A point to a direction is what I need!