Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to get data out of SQL Server
Hello,
I have a VB.NET app that uses SQL Server. The front-end is an ASP.NET app that runs at an ISP. I would like to let my client pull up an ASPX page, request some pre-canned query where they perhaps supply a transaction date range for my job table, and then I want to run that query against SQL Server. All of this stuff I can do with no problem...but the result of the query isn't to be displayed on a web page. I would like to have it saved on the requesters machine in a format that excel can utilize. Ideally after the query runs I would like it to prompt the user with a file dialog that asks them what filename would they like to save it to. What is the best approach to take on this? Does the data have to be formatted a particular way, comma delimited, xml? Thanks...Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to get data out of SQL Server
Excel 2002 and later can read xml. I don't believe earlier versions can.
Comma delimited (CSV) should be readable by excel and would be the easiest. -- Regards, Tom Ogilvy "paul reed" wrote in message ... Hello, I have a VB.NET app that uses SQL Server. The front-end is an ASP.NET app that runs at an ISP. I would like to let my client pull up an ASPX page, request some pre-canned query where they perhaps supply a transaction date range for my job table, and then I want to run that query against SQL Server. All of this stuff I can do with no problem...but the result of the query isn't to be displayed on a web page. I would like to have it saved on the requesters machine in a format that excel can utilize. Ideally after the query runs I would like it to prompt the user with a file dialog that asks them what filename would they like to save it to. What is the best approach to take on this? Does the data have to be formatted a particular way, comma delimited, xml? Thanks...Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to get data out of SQL Server
Hi paul,
Very good question! Based on my experience on this issue, I'd suggest you can check this KB article from Microsoft.com which will help you a lot on this issue. Please go to: 317719 HOW TO: Export Data in a DataGrid on an ASP . NET WebForm to Microsoft http://support.microsoft.com/?id=317719 In addition, Microsoft Office 2000 supports HTML/XML as a native file format which means that Excel 2000 supports XML. Does this answer your question? Thank you for using Microsoft NewsGroup! Wei-Dong Xu Microsoft Product Support Services Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data into SQL Server from Excel | Excel Discussion (Misc queries) | |||
How to import data from SQL Server | Excel Discussion (Misc queries) | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |