Data Import

[Alexey]

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

 

[Guest]

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--