How to get data from Excel User Interface and save it in MS SQL Server Express

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.

Use ADO. See the Connection Strings section for the string for SQL Server and other code at: http://www.erlandsendata.no/english/...php?t=envbadac

Have a look and see if this gets you going: http://www.excelforum.com/tips-and-t...ql-server.html

Thanks Kyle and Kenneth. I will try it and will let you know how it goes.

Thanks.

Hi Kyle, I read your article. It's excellent. I would love to see part 2. I know you said you didn't get a chance to write it up, but I am sure many forum users would love to read it. Anyways if I will have any queries, I will post it.
Thanks.

I didn't ever finish it off since no-one was really bothered/asked for it - I wrote part one as I was asked for an introduction.

I'll see if I can find time to do part two since it would help