Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Download data from website
I am building a reporting solution with Excel 2000. I would like the
spreadsheet to be able to download data from SQL Server on our website. The data will go into a specific range on my spreadsheet on which further calculations can then take place. If possible I want this to be controlled from Excel i.e. User will press a button on a customized Excel toolbar which will then run some code to carry out the above. Can this be done. Thanks in advance Sanjay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Download data from website
Yes, that all can be done.
To start, try using Data | Get External Data, New Database Query... you can record a macro while you do that, which will give you the basic code that you need to connect to the SQL server. Regards, Juan Pablo González "Sanjay Singh" wrote in message ... I am building a reporting solution with Excel 2000. I would like the spreadsheet to be able to download data from SQL Server on our website. The data will go into a specific range on my spreadsheet on which further calculations can then take place. If possible I want this to be controlled from Excel i.e. User will press a button on a customized Excel toolbar which will then run some code to carry out the above. Can this be done. Thanks in advance Sanjay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Download data from website
Is there any way to try and get the information from an ASP page instead of
directly from the SQL Server. Thanks Sanjay "Juan Pablo Gonzalez" wrote in message ... Yes, that all can be done. To start, try using Data | Get External Data, New Database Query... you can record a macro while you do that, which will give you the basic code that you need to connect to the SQL server. Regards, Juan Pablo González "Sanjay Singh" wrote in message ... I am building a reporting solution with Excel 2000. I would like the spreadsheet to be able to download data from SQL Server on our website. The data will go into a specific range on my spreadsheet on which further calculations can then take place. If possible I want this to be controlled from Excel i.e. User will press a button on a customized Excel toolbar which will then run some code to carry out the above. Can this be done. Thanks in advance Sanjay |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Download data from website
Hi Sanjay,
Sanjay Singh wrote: Is there any way to try and get the information from an ASP page instead of directly from the SQL Server. Yes - instead of a new database query, you would build a new web query via Data | Import External Data. You can specify what table(s) you want to import and where you want to put them. It should do what you're looking for. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I download analysis toolpak from the microsoft website? | Excel Discussion (Misc queries) | |||
How do I download data into MS Excel from a Website that takes a l | Excel Worksheet Functions | |||
Download excel doc from website, can this be done? | Excel Worksheet Functions | |||
want to download csv file from website and need to open in Excel. | Excel Discussion (Misc queries) | |||
Need vb to automatically download from https website | Excel Programming |