Data Import
 

Hi,

I need to analyse some data that is held in an Access database, but I want
to do this in Excel.

I have the data in an Access Query.

My data is about 7500 records and increasing by 200 records per month.

The data record consists of three fields

Date in mmm-yy format

Text String1

Text String2



I want to group my data in Excel by month with the latest month at the top.
I then want to have a count of TextString1 and a count of TextString2. As
an example:



Month Text String1
Text String 2

Sept-07 25
36

Aug -07 62
89



I am lost as to the best way of doing this, and would appreciate some advise
please



Thanks

A

Data Import
 

Data Import External Data New DB Query MS Access DB OK.
Then, when the data is in Excel, Data Sort.

Does this help?


Post back if you need more info.

Ryan--

--
RyGuy


"Alexey" wrote:

Hi,

I need to analyse some data that is held in an Access database, but I want
to do this in Excel.

I have the data in an Access Query.

My data is about 7500 records and increasing by 200 records per month.

The data record consists of three fields

Date in mmm-yy format

Text String1

Text String2



I want to group my data in Excel by month with the latest month at the top.
I then want to have a count of TextString1 and a count of TextString2. As
an example:



Month Text String1
Text String 2

Sept-07 25
36

Aug -07 62
89



I am lost as to the best way of doing this, and would appreciate some advise
please



Thanks

A