Reporting form based on excel data

Microsoft Office access 2007 (full produ...
February 23, 2010 at 12:47:28
Specs: Windows XP
I have a query relating to access. I have lniked an excel file, with around 1000 entries in it. There are three relevant columns - School, Dept and Section. I want access to have a form that allows me to have a drop down for each of these, so for example if i want to count how many out of the 1000+ are going from a certain school to a certain dept and section when i select them, it cant be done in excel as there are too many entries, btu im told it can be done in access? thanks in advance

See More: Reporting form based on excel data

Report •

February 23, 2010 at 20:21:56
re: "it cant be done in excel as there are too many entries"

I do not believe that to be the case. Please see Response #9 of your other thread.

I was able to get it working with 30,000 rows of data in each of 3 workbooks.

Report •

February 26, 2010 at 05:57:37

Have you considered using the database functions within Excel.

I recently worked on an Excel 'database' consisting of over 7000 rows and 24 columns.

I used the database functions to return results based on selecting items that matched criteria in 11 columns.
The results appeared almost instantaneously - and that's on my laptop which is not the latest and greatest!

The Excel function I used was DCOUNTA
'Counts the nonblank cells in a column of a list or database that match conditions that you specify'.

As your data is already in Excel, it saves moving everything to Access.

I do have a small example Worksheet using Excel's database functions. The worksheet is annotated.

If you are interested, let me have your e-mail address via private messaging and I will send the workbook to you.


Report •

Related Solutions

Ask Question