473,386 Members | 1,795 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,386 software developers and data experts.

display the results of a SP in excel?

Hi

I wanted to display the results of a SP in excel

The Sp returns 2 values - the count of no of records in 2 tables

I got the results in a Recordset but when i tried to display it only the first

returned value is getin displayed ??
Jun 5 '07 #1
1 1093
its very easy to do the same with an ssis package if there are a lot of records to be populated and in mycase it was a mistake while using the record set!

Hi

I wanted to display the results of a SP in excel

The Sp returns 2 values - the count of no of records in 2 tables

I got the results in a Recordset but when i tried to display it only the first

returned value is getin displayed ??
Mar 25 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Suffrinmick | last post by:
Hello Everyone I've built a database using Access 2000 which includes a query which is built using a form containing filters. No problem. When I export the results of the query to excel, (File >...
9
by: Lukman | last post by:
Hi, Do you know how to display ASP.NET result (database result from ADO.NET) using Excel in IE ? Thanks,
7
by: c.verma | last post by:
I have a web application. There is a page which has a datagrid on it.The datagrid displays the data that comes from SAP. SAP sends the chinese characters to this grid. Before I display CHinese...
2
by: Mad Scientist Jr | last post by:
>From an asp.net web page I want the user to open the results of a SQL query in Excel, as automatically as possible (ie not having to loop through columns, rows, in code). For this,...
3
by: =?Utf-8?B?bWFyeGk=?= | last post by:
as you know, when we input a formula in cell of axspreedsheet, it will become its responsed result. But I need it display the formula rather than its results! -- marxi
4
by: ms.wcchan | last post by:
Dearest I.T. professional, I am now doing a survey and would like to ask all customers to submit the questionnaire online so that I can collect the results in the excel file. What programming...
10
by: dancer | last post by:
How can I save the results of a fill-in form to a Microsoft Excel spreadsheet? I can insert the results into an Access table, but the reports are so tedious to make from Access. Reports are very...
4
by: Yitzak | last post by:
Have a query that is arregated into crosstab query, it is working correctly. select Yes as selected from tblname or select true as selected from tblname Produces -1 ( vba value of True) in...
0
by: JP Romano | last post by:
Hi... I'd like to display the results of a formula on a userform to alert users that certain operations are still in progress. Essentially, when the user clicks a button to compile results from...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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?
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.