Hi there,

Again, I'm struggling with displaying information online using an Excel Worksheet as source. I searched the Net and finally was able to make the connection via ADODB. However, I noticed that this way of working excludes quite some options if it comes to filtering, sorting etc. eg. empty values in cells are not recognized when launching a filter on empty values. Feel quite desperate as I would like to have this working. Any advice ? Should I export this to a temp database before working on this ? Is it ever going to work ? Thanks.

Sebastiaan.

What exactly are you trying to do? export information on an ASP page to exell? Have you thought of creating a CSV file .xls. .csv they are the same thing except .csv is better - more portable. You can write scripts the same way as you do rendering a regular .asp page - will this do the job?

Wind is your friend
Matt

Hi Mat,

Basically, what I would like to do is cross-reference two sepearate Excel sheets.

Ready for some SAP rubbish :

Sheet 1 : holds all the clients that have received a package successfully/unsuccessfully, based on a value indicating -100/-999.
Sheet 2 : holds the remaining upgrade files that are in the outbound queues of some clients.

Anyways, displaying / filtering / sorting the information should be a straightforward job in this case. I would like to use the asp file to give some facts and figures automatically.

- How many people have received the upgrade.
- How many people are still left out
- What is the total amount of people registered on the SAP system etc.

Is there a way I can convert the sheet to a RecordSet as I have the feeling that rows in an Excel sheet are not considered as records. it is something weird.

Really, some simple stuff, ever worked with SAP, it is definetely not Microsoft.

Thanks,

Sebastiaan.