New To access.. Importing and using question

[laythss]

Hello all, I am all new to access and I am trying to convert a program I made from excel VBA to ASP.net using access data bases. I am not even sure if this is possible, but I started looking into access couple of days ago, and reading examples of using it for websites etc. that I think it might have the potential.
My question is:
I have an excel file that has the following format:
months 1 2 3 4 5 6 7 8 9 10 11 12
Products

product1 20 5 9 8 etc
product2 9 6 7 3
product3 8 4 2 1
product4 100 26 78 32
.
.
.

Now the way I pull data out of this sheet of excel is if a user asks for the total number of products sold in february, the program will search for the month (2 in this case and that would be the fixed column) then it will add up all the entries in that column after row 1 (row one is the row that has the month numbers) and display the total (for this example it would be 41).

This is a real simplification of what is done but I think is brings out my question of how to build a data base for such data where I would need to make a 2 dimensional search, since from what I could not figure out how to incorperate my months into the data base in access when I tried to convert the file from excel to a database table in access.

I hope someone could help me. and I thank you all for you comments and replies in advance.

 

[Pat Hartman]

Tables are not spreadsheets and if you try to just port a spreadsheet to a relational database, you will be sadly disappointed. You need to normalize the data in order to work with it effectively.

You will end up with a table with three columns:

ProductID
TransactionDate
Quantity

The table will end up with a row for every combination of product and date.