How can I allow uploading and mapping of Excel file to relational database?
Posted on 2008-10-03
I've seen some online control panels where you can upload a delimited file, then it takes you to a screen where you can map the column headers of the delimited file to the database column names. How can I do this so I can allow uploading of an Excel file, then the page lists the column headers with a dropdown to the database table columns next to it? I intend on saving that "mapping" to an XML file. I'm using this with an MS SQL 2008 and Access 2007 database. Has anyone done anything like this before?