This is a two part question.
At our company we keep all our inventory on an excel spread sheet. It is getting very hard to work with, as our numbers are growing. I have designed a relation database in SQL and would like to know how to populate the data from the excel spreadsheet into the database. I am creating an application to interact with this database. I am using the .net framework 3.5 and code mainly in VB. The excel data is on one sheet, but the database has multiple tables. This is the first database that I have designed, and although I am familiar with the concept of relational databases, I would like to know if my database is designed properly.
1. What is the best way to populate a multiple table database with data from an excel sheet?
2. Is my database appropriately designed? Am I making it too complicated or am I missing important concepts? (I have attached a .bmp of the database design.)
Thanks for any help you guys can give me!