Transferring Data From Excel

[garrettgivre]

I have an excel sheet that is full of counts from various companies for various dates. Many of these companies are reoccurring. Each company has a shorthand code that I use to keep track of it.

For example:

21-Aug	Not Qualified	Dupes	Qualified	Total
BXTHEATER 13	31	123	507	661
Totals	31	123	507	661
22-Aug	Not Qualified	Dupes	Qualified	Total
CTINFAIR 13	100	275	1948	2323
CTNORTH 13	3	3	75	81
CTLINCOLN 13	21	60	413	494
CTSOUTH 13	10	13	170	193
Totals	134	351	2606	3091
27-Aug	Not Qualified	Dupes	Qualified	Total
MSFLPANA 13	1	69	218	288
MSDDLVE 13	0	0	221	221
MSFLSANTA 13	0	19	123	142
MSLAOAK 13	1	118	365	484
MSFLCORD 13	13	35	478	526
MSLAPECAN 13	2	179	599	780
MSLAMALL 13	5	125	699	829
MSALBELL 13	9	192	929	1130
CTAPFAIR 13	52	243	1179	1474
CTFLEA 13	66	222	957	1023
Totals	149	1202	5768	6897
28-Aug	Not Qualified	Dupes	Qualified	Total
CTAPFAIR 13	68	396	1362	1826
CTFLEA 13	30	109	472	611
ELIASTFAIR 13	108	36	1014	1158
Totals	206	541	2848	3595

Each of the total fields is calculated using a "=sum(A2:B2)" formula to add from the column above it for that date.

I have data for the entire year, starting on 1-Jan. What I would like to be able to do is pull data using access for, lets say, what CTAPFAIR did in the month of July, or what my total count for the year for one source is.

What would be the best way to create a database in access with this data?

If more information is needed please let me know.

[June7]

Access could not effectively link to that structure. Need to normalize like:

CompanyID	SummaryDate	NotQual	Dupes	Qual
BXTHEATER	8/21/2013	31	123	507
CTINFAIR 13	8/22/2013	100	275	1948
CTNORTH 13	8/22/2013	3	3	75
CTLINCOLN 13	8/22/2013	21	60	413
CTSOUTH 13	8/22/2013	10	13	170

Some might take the normalization another step with:

CompanyID	SummaryDate	Cat	Amount
BXTHEATER	8/21/2013	NQ	31
BXTHEATER	8/21/2013	D	123
BXTHEATER	8/21/2013	Q	507
CTINFAIR 13	8/22/2013	NQ	100
CTINFAIR 13	8/22/2013	D	275
CTINFAIR 13	8/22/2013	Q	1948

Row and column totals would be generated by calculations in queries/forms/reports.

[garrettgivre]

Access could not effectively link to that structure. Need to normalize like:

CompanyID	SummaryDate	NotQual	Dupes	Qual
BXTHEATER	8/21/2013	31	123	507
CTINFAIR 13	8/22/2013	100	275	1948
CTNORTH 13	8/22/2013	3	3	75
CTLINCOLN 13	8/22/2013	21	60	413
CTSOUTH 13	8/22/2013	10	13	170

Some might take the normalization another step with:

CompanyID	SummaryDate	Cat	Amount
BXTHEATER	8/21/2013	NQ	31
BXTHEATER	8/21/2013	D	123
BXTHEATER	8/21/2013	Q	507
CTINFAIR 13	8/22/2013	NQ	100
CTINFAIR 13	8/22/2013	D	275
CTINFAIR 13	8/22/2013	Q	1948

Row and column totals would be generated by calculations in queries/forms/reports.

This is a good solution. This is a great way to organize the data so access will be able to interpret it. I do wish there were a way to directly interpret it, but I dont mind doing it this way to save time in the long run.