Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2004, 04:31 PM
Authorized User
 
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Working with Excel Worksheet as ADODB.RecordSet

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.
 
Old May 24th, 2004, 06:00 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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
 
Old May 25th, 2004, 03:10 AM
Authorized User
 
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Worksheet Functions Stop Working Arron Edwards Excel VBA 1 May 13th, 2008 01:12 AM
Recordset pages on a worksheet meherzadirani Access VBA 0 January 3rd, 2008 10:36 AM
ADODB Recordset sporkman43 Classic ASP Basics 4 November 9th, 2006 04:51 AM
ADODB.Recordset (0x800A0CB3)Current Recordset does tks_muthu Classic ASP Databases 0 June 16th, 2005 07:22 AM
How to get adodb.record from adodb.recordset John Pennington Pro VB Databases 1 November 20th, 2004 06:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.