Access Query From Excel 2

[VC2002]

Hi!

I'm running a query in Excel from an Access Database.

The table in Access has a date column and a price column, and contains about 3000 records.

I want to limit the query in Excel to the 200 most recent records.

Any ideas out there?!

Thanks,

VC

 

[dwlerwill]

something like

SELECT TOP 200 Connections.ID, Connections.Temp
FROM Connections;



David Lerwill
"If at first you don't succeed go to the pub"

 

[cheerio]

To get the 200 most recent you need an order by clause otherwise you get the first 200 records found.

eg ORDER BY tran_date DESC

 

[dwlerwill]

Good point

David Lerwill
"If at first you don't succeed go to the pub"

 

[VC2002]

Thanks a lot to both of you!

VC