Hi there,

I am using an Excel User interface where users enter data for a product. The Excel user interface is not in tabular format, it has fields placed such that the worksheet looks like a form.

The information from the Excel user interface will be saved in multiple tables. For example, the product description from excel is to be saved in Product_Details table and the product cost from excel is to be saved in Product_Finance table. I want to store the data from excel into MS SQL Server Express. I have already created the required tables in SQL Server database.

Can someone help me with the best possible way to save this data from Excel to SQL Server? I am also happy to use stored procedures for this if required. If someone can guide me with a link or any article where this has been explained, that would be really helpful.

Awaiting response.

Thanks.