MDB too large (and I don't have access)

[RSXchin]

My company has a godawful database program that will only allow certain pre-written queries. I would like to create the queries myself, but they won't allow access to be installed.

I can use the import data into excel, but I can only show the first 65000 records (yeah, 2003... I hate them so much).

I can use 65000 records, but I don't know how to show only the most recent ones. It'd be even better if I could only show the most recent 2000 or so.

Help me Obiwan Kenobi. You're my only hope.

 

[Norie]

When importing the data do you have the option to query it, perhaps using MS Query?

If you do you could write your queries there using some simple SQL statements.

For example if you only want recent records, and there is a date field or similar in the table you can set the criteria to only return the records for a certain time period.

 

[RSXchin]

I'm afraid I've never written queries, if you could maybe write this first one for me maybe?

and there ARE 2 useful columns for this. "TransID" and "DateTimeStamp".
Since,
1. it is on an interprise machine
2. I only have 1 screen
3. I can't print and retype any lengthy vba

I'd prefer to use the interface as is. Also, I thought 2003 had a wizard. Can't find him.

 

[RSXchin]

No help? :'(

 

[RoryA]

You basically want a "select top 2000 * from tablename order by transid" type
Query. Asking a bit much to be taught SQL in one question...

 

[RSXchin]

wont excel run out of resources? I mean, this database is almost a Gig.

 

[RoryA]

It shouldn't do as you are not loading the entire database into Excel, but you won't know until you try. If it does, then this whole question seems moot.
Does your company not have SQL Server or another proper RDBMS - 1GB is a little large for Access in my opinion (and yes I know it will technically handle larger files)

 

[RSXchin]

I'm sorry to crosspost (well, not really crosspost). But I don't have all the information I need for the query. I don't have the actual field names... Is there an sql query I can do?

(preferably, reply to the access thread for future users)

http://www.mrexcel.com/forum/showthread.php?t=565504

 

[RSXchin]

whoops

 

[Norie]

You don't need the field names .

The query Rory posted will return all the fields in the table.

Why don't you download Microsoft's SQL Express?