Brachole
04-28-2010, 10:16 AM
I have this website that allows users to create a profile with equipment they own. A table in the database is already existent with columns such as:
Manufacturer
Model Number
Serial Number
Location
My ASP page allows for the user to enter this information one at a time to be inserted.
However, the user may already have that information in an Excel Spreadsheet. It would be nice for the user to be able to upload that Spreadsheet without haing to re-type them all.
Problem is, I have no control on the Columns the user's Spreadsheet has...is it even possible to upload it to the Database without knowing the column names or its order or even if some of the column exist?
Manufacturer
Model Number
Serial Number
Location
My ASP page allows for the user to enter this information one at a time to be inserted.
However, the user may already have that information in an Excel Spreadsheet. It would be nice for the user to be able to upload that Spreadsheet without haing to re-type them all.
Problem is, I have no control on the Columns the user's Spreadsheet has...is it even possible to upload it to the Database without knowing the column names or its order or even if some of the column exist?