Use Excel to analyze Access data

[ilcaa]

I have been using Excel to analyze 4 columns and 60,000 rows of data
so all my cell functions reference Columns Names i created. My dat
has grown to over 75,000 rows which I download on a daily basis so
started saving it in Access.

This might seem like a really basic question but how do I use Excel t
analyze the data using the same template i created now that the dat
is stored in Access?? I assume I can just reference the Acces
fields and change my formulas to include this but not sure how to d
this and everything I find is about importing to excel which i can
do because of row limitations, any help with this?....thanks

 

[Douglas J Steele]

You can't. Excel can't handle 75,000 rows in a spreadsheet.

Do a search on "Specifications" in the Excel help. You'll find that the
limit for a spreadsheet is 65,536 rows by 256 columns.

 

[Joseph Meehan]

I have been using Excel to analyze 4 columns and 60,000 rows of data,
so all my cell functions reference Columns Names i created. My data
has grown to over 75,000 rows which I download on a daily basis so I
started saving it in Access..

This might seem like a really basic question but how do I use Excel to
analyze the data using the same template i created now that the data
is stored in Access?? I assume I can just reference the Access
fields and change my formulas to include this but not sure how to do
this and everything I find is about importing to excel which i cant
do because of row limitations, any help with this?....thanks.

As I recall you can't. Excel, I believe, tops out at 64,536 rows. It
can't handle 75,000. You will need to split it up, combine values or just
do what you need in Access. You are outgrowing Excel, you get to play with
the big tools like Access now.

 

[Joseph Meehan]

I have been using Excel to analyze 4 columns and 60,000 rows of data,
so all my cell functions reference Columns Names i created. My data
has grown to over 75,000 rows which I download on a daily basis so I
started saving it in Access..

This might seem like a really basic question but how do I use Excel to
analyze the data using the same template i created now that the data
is stored in Access?? I assume I can just reference the Access
fields and change my formulas to include this but not sure how to do
this and everything I find is about importing to excel which i cant
do because of row limitations, any help with this?....thanks.

Since you are now over the 64K limit in Excel, I would guess you will
need to limit the number of records you are analyzing somehow. That could
be a problem depending on the data and exactly what you are analyzing. You
could make a query that would select the records you want to see in Excel
and then pick up the data from the query.