473,411 Members | 2,078 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,411 software developers and data experts.

Streaming query results into XCEL spreadsheet

ben
I am working on a classic ASP application. This application needs to run an
SQL query and take the result set and stream it into an XCEL spreadsheet for
processsing by the users. Is there an ASP method of third party product to
do this?
Jul 19 '05 #1
1 1485
Are you talking about inserting data into an EXISTING _E_xcel workbook, or
just returning your recordset to the user as a spreadsheet?

Ray at work

"ben" <be***********@fldoe.org> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
I am working on a classic ASP application. This application needs to run an
SQL query and take the result set and stream it into an XCEL spreadsheet
for
processsing by the users. Is there an ASP method of third party product
to
do this?

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sid | last post by:
You can deliver Cold Fusion query results to your users in a spreadsheet. Control not only which columns go in the spreadsheet, but their order as well. Get all details (and download a...
1
by: William.R.Reisen | last post by:
Hi, I have currently in Xcel and long list of X English phrases in one column with associated numerical data about each name in adjoining columns. I have on another workbook (which could of...
2
by: Matthew Kramer | last post by:
Once you have created a table through a query, is there a way to make that dataset into an Access "table" rather than a table/dataset generated by a query? Maybe someway to cut and paste the...
1
by: Steve | last post by:
I imported data from a spreadsheet into an access table. is there a way to deal with the empty cells? currently they are empty fields but I dont know how to interact with them. This is my first...
9
by: egrill | last post by:
I am looking for away to link the results of my query to an Excel spreadsheet that will automatically update and then emailed. Right now I export and send. I need a more efficient way. It is...
0
by: Rand | last post by:
I'm building a 'search' form in my database which will be used to select specific records from a table. I use input from the form controls to build a query (with a variable number of columns)...
2
by: bob | last post by:
Hi, Trying to format a column to text so that I can have leading 0's in some numbers. Can't have quotes around the numbers so need to format cells. tried Range rge = ws.get_Range("F1", "F80");...
12
by: TARHEELS721 | last post by:
I am trying to send the results of a query that runs when I click a button on my form that is based on a parameter query. The code runs without any errors but nothing is exported into my excel...
4
by: franc sutherland | last post by:
Hello, I am using Access 2003. I am having trouble trapping the "can't append all the records in the append query" error message when appending data to a query from a table which is linked to...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.