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.

 

[RSXchin]

The computer in question has no internet connection, and I'm not allowed to install any programs. Including Access.

 

[RSXchin]

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

I think that last part was freezing excel. Still haven't tried yet. Someone else is on that computer. Playing Spider Solitare........

 

[Norie]

So how are you expected to deal with something like this?

How was it even created if Access isn't available?

 

[RSXchin]

please send all replies to
http://www.mrexcel.com/forum/showthread.php?t=565504

I don't want this to get messy.