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 October 6th, 2003, 02:36 PM
Registered User
 
Join Date: Sep 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default .asp request from Excel (Import External Data)

Hi
my problem is that I would like to import data into Excel (with "Import External Data") from a database that is queried with an .asp command such as http://www.nysedata.com/queries/makeQuery10a.asp

Is that possible at all ?

Thx,

Oliver

The source code of the page is as follow:


code:
--------------------------------------------------------------------------------
<html>
<head>
<base href="http://www.nysedata.com/">
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<noscript><meta HTTP-EQUIV="refresh" CONTENT="1; URL=../browserError.asp"></noscript>
<title>NYSEData.com - Trade History Database</title>
<link rel="stylesheet" type="text/css" href="css/standard2.css">
<script language="JavaScript" src="scripts/formValidation.js"></script>
<script language="JavaScript" src="scripts/datePicker.js"></script>
<script language="Javascript">
function doOpenWin(whichB)
{
   var newWin;
   if (whichB=="symbol")
   { newWin = window.open('http://www.nysedata.com/findsymbol.asp','symbollookup','resizable,scrollba rs=yes,width=425,height=400,left=100,top=100'); }
   if (whichB=="help")
   { newWin = window.open('http://www.nysedata.com/database/tradehistory.htm','help','resizable,scrollbars=yes ,width=500,height=600,left=100,top=100'); }
   if (!newWin.opener)
   { newWin.opener=self; }
   newWin.opener.name="NYSEData";
   newWin.focus();
   return;
}
function doSubmit(form)
{
   var errMsg = "Please enter symbol";
   if (!checkTextField(form.querySymbol,errMsg))
   { return; }
   errMsg = "Please enter valid Date";
   if (!checkDate(form.queryDate,errMsg))
   { return; }
   errMsg = "End Date must occur after Begin Date.";
   if ( !compareTime(form.queryTimeBegin,form.beginAMPM.op tions[form.beginAMPM.selectedIndex],false,form.queryTimeEnd,form.endAMPM.options[form.endAMPM.selectedIndex],false,errMsg) )
   { return; }
   errMsg = "Please check at least one check box to proceed";
   var checkBoxIsChecked = false;
   for (i=0; i<form.queryExchange.length; i++)
   {
      if (form.queryExchange[i].checked)
      { checkBoxIsChecked = true; }
   }
   if (!checkBoxIsChecked)
   { alert(errMsg); return; }
   form.submit();
}
</script>
<meta name="Microsoft Border" content="none, default">
</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="100%">
<table background="/images/banner_back4.gif" width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td>
     <table width="100%" border="0" cellpadding="0" cellspacing="0">
       <tr>
         <td>
           <table border="0" cellpadding="0" cellspacing="0">
             <tr>
               <td></td>
               <td><img src="/images/clearpix.gif" height="5" width="1"></td>
             </tr>
             <tr>
               <td><img src="/images/clearpix.gif" width="10"></td>
               <td><a href="info/about.asp"><img border="0" src="images/logo_dkblu_50_7.gif"></a></td>
             </tr>
             <tr>
               <td></td>
               <td><img src="/images/clearpix.gif" height="5" width="1"></td>
             </tr>
           </table>
         </td>
         <td valign="top">
           <table width="100%" border="0" cellpadding="0" cellspacing="0">
             <tr>
               <td></td>
               <td align="right" valign="top" width="470">
              <table border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td valign="bottom" class="bannerColor"><img src="/images/curve_botleft.gif" WIDTH="10" HEIGHT="15"></td>
                  <td class="bannerTopRight" align="right" nowrap> <a href="http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmDataVending?readform" class="bannerLinks">Market Data Services</a> | <a href="http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmAdminServices?readform" class="bannerLinks">Vendor Services</a> | <a href="http://www.nysedata.com/openbook" class="bannerLinks">NYSE Openbook</a> | <a href="http://marketrac.nyse.com/detector/welcome.html" class="bannerLinks">MarkeTrac</a> | <a href="http://www.nyse.com" class="bannerLinks">NYSE.com</a></td>
                  <td class="bannerColor" align="right"><img src="/images/clearpix.gif" width="10" height="1"></td>
                </tr>
              </table>
               </td>
             </tr>
             <tr>
               <td><img src="/images/clearpix.gif" width="90" height="1"></td>
               <td align="right">
                 <table border="0" cellpadding="0" cellspacing="0">
                   <tr>
                     <td><img src="/images/clearpix.gif" height="44" width="1"></td>
                     <td width="220" bgcolor="#15205E" align="center"><a href="/brokervolume/default.asp"><img src="/images/ad_brokervol2.gif" border="0" WIDTH="220" HEIGHT="44"></a></td>
                     <td width="220" bgcolor="#15205E" align="center"><a href="/liquidity/default.asp"><img src="/images/ad_liquidity.gif" border="0" WIDTH="220" HEIGHT="44"></a></td>
                   </tr>
                 </table>
               </td>
             </tr>
           </table>
         </td>
       </tr>
     </table>
   </td>
  </tr>
  <tr>
    <td>
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="130" class="bannerIndex" align="center" nowrap> <a href="/home.asp" class="bannerIndex">Home</a></td>
          <td width="20" valign="top" class="bannerColor" nowrap><img src="/images/curve_banner_2.gif" WIDTH="20" HEIGHT="25"></td>
          <td class="bannerColor" nowrap></td>
          <td width="10" align="right" valign="top" class="bannerColor" nowrap><img src="/images/clearpix.gif" WIDTH="10" HEIGHT="25"></td>
        <td class="bannerColor" valign="center" align="right" nowrap><a href="/logout.asp" class="bannerLogInOut"><b>Log Out</b></a></td>
          <td width="10" align="right" valign="top" class="bannerColor" nowrap><img src="/images/clearpix.gif" WIDTH="10" HEIGHT="25"></td>
        </tr>

      <tr>
        <td class="bannerColor" width="130"></td>
        <td bgcolor="#ffffff" align="left"><img src="/images/curve2_banner.gif" WIDTH="20" HEIGHT="10"></td>
        <td bgcolor="#ffffff" colspan="4"></td>
      </tr>

      </table>
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
<table border="0" width="760" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" width="135"><script language="JavaScript1.2" src="scripts/menuScripts/menuScriptv4.js" type="text/javascript"></script>
<script>
var oM=new makeCM("oM")
oM.pxBetween=2;
oM.fromTop=100;
oM.fromLeft=0;
oM.menuPlacement="left";
oM.wait=600;
oM.fillImg="images/cm_fill.gif";
oM.zIndex=100;
oM.resizeCheck=1;
oM.zIndex=100;
oM.onlineRoot="http://www.nysedata.com/";
oM.offlineRoot="";
oM.rows=0;
oM.frames=0;
oM.useBar=0;
oM.barWidth="135";
oM.barHeight="18";
oM.barX=0;
oM.barY="menu";
oM.barClass="mclBar";
oM.barBorderX=0;
oM.barBorderY=2;
oM.barBorderClass="mclB";
oM.level[0]= new cm_makeLevel(135,20,"mclT","mclTover",0,1,"mclB1", 0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.level[1]= new cm_makeLevel(140,20,"mclS","mclSover",1,1,"mclB1", 0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.level[2]= new cm_makeLevel(155,20,"mclS2","mclS2over",1,1,"mclB1 ",0,"right",0,0,"images/jsMenuArrow.gif",7,7)
oM.makeMenu('m738','','Your Data','currentData.asp','','','');
oM.makeMenu('m512','','Your Account','','','','');
oM.makeMenu('m519','m512','Account Information','editProfile/viewProfile.asp','','','');
oM.makeMenu('m520','m512','Current Subscriptions','currentData.asp','','','');
oM.makeMenu('m521','m512','New Subscription','subscribe/p1ChooseProduct.asp','','','');
oM.makeMenu('m522','m512','Billing','editprofile/editBillingInfo.asp','','','');
oM.makeMenu('m524','m512','Email Preferences','editSubscription/editSubscriptions.asp','','','');
oM.makeMenu('m744','','NYSE Fact Book','factbook/main.asp','','','');
oM.makeMenu('m513','','Data Products','','','','');
oM.makeMenu('m526','m513','List of Products','info/productList.asp','','','');
oM.makeMenu('m527','m513','Broker Volume','','','','');
oM.makeMenu('m539','m527','Become a vendor','brokerVolume/Vregistration1.asp','','','');
oM.makeMenu('m540','m527','Database','','','','');
oM.makeMenu('m545','m540','FAQ','brokervolume/FAQ.asp','','','');
oM.makeMenu('m546','m540','Pricing','brokervolume/pricing.asp','','','');
oM.makeMenu('m547','m540','Sample','BrokerVolume/brokervol200212.zip','','','');
oM.makeMenu('m548','m540','Schema','brokervolume/BVSpecifications.asp','','','');
oM.makeMenu('m549','m540','Subscribe','brokervolum e/Vregistration1.asp','','','');
oM.makeMenu('m550','m540','Viewer','brokervolume/viewer.asp','','','');
oM.makeMenu('m541','m527','Participate','brokervol ume/instructions.asp','','','');
oM.makeMenu('m542','m527','Reports','','','','');
oM.makeMenu('m551','m542','Demonstration','brokerv olume/demo/volumebyfirm.asp','','','');
oM.makeMenu('m552','m542','Pricing','brokervolume/pricing.asp','','','');
oM.makeMenu('m554','m542','Subscribe via Authorized Vendor','brokervolume/vendors.asp','','','33');
oM.makeMenu('m528','m513','Liquidity Quote','liquidity/default.asp','','','');
oM.makeMenu('m529','m513','OpenBook','openbook/default.asp','','','');
oM.makeMenu('m530','m513','Trades and Quotes','','','','');
oM.makeMenu('m561','m530','Historical','','','','' );
oM.makeMenu('m563','m561','Daily TAQ FTP','info/productDetail.asp?dpbID=13','','','');
oM.makeMenu('m564','m561','TAQ Web','info/productDetail.asp?dpbID=10','','','');
oM.makeMenu('m562','m530','Real Time','info/ctcq.asp','','','');
oM.makeMenu('m531','m513','Stock Prices','','','','');
oM.makeMenu('m565','m531','Delayed','info/delayedPrices.asp','','','');
oM.makeMenu('m566','m531','End of Day','','','','');
oM.makeMenu('m570','m566','Closing Summary','info/productDetail.asp?dpbID=5','','','');
oM.makeMenu('m567','m531','Historical','','','','' );
oM.makeMenu('m571','m567','Daily TAQ FTP','info/productDetail.asp?dpbID=13','','','');
oM.makeMenu('m572','m567','TAQ Web','info/productDetail.asp?dpbID=10','','','');
oM.makeMenu('m568','m531','Pre-Opening','','','','');
oM.makeMenu('m573','m568','ITS Indications','mdx/','','','');
oM.makeMenu('m569','m531','Real Time','info/ctcq.asp','','','');
oM.makeMenu('m532','m513','Bonds','','','','');
oM.makeMenu('m575','m532','Bonds - Trades','info/productDetail.asp?dpbID=15','','','');
oM.makeMenu('m574','m532','Bonds - Quotes','info/productDetail.asp?dpbID=14','','','');
oM.makeMenu('m533','m513','Limit Orders','','','','');
oM.makeMenu('m576','m533','Real Time','openbook/default.asp','','','');
oM.makeMenu('m577','m533','Historical','','','','' );
oM.makeMenu('m578','m577','OpenBook FTP','info/productDetail.asp?dpbID=12','','','');
oM.makeMenu('m579','m577','OpenBook Web','info/productDetail.asp?dpbID=16','','','');
oM.makeMenu('m534','m513','Dollar Volume','info/productDetail.asp?dpbID=18','','','');
oM.makeMenu('m535','m513','Short Interest','info/productDetail.asp?dpbID=7','','','');
oM.makeMenu('m536','m513','Corporate Actions','info/productDetail.asp?dpbID=29','','','');
oM.makeMenu('m537','m513','Administrative','','',' ','');
oM.makeMenu('m580','m537','Post & Specialist','info/productDetail.asp?dpbID=1','','','');
oM.makeMenu('m581','m537','Master File','info/productDetail.asp?dpbID=2','','','');
oM.makeMenu('m582','m537','Symbol File','info/productDetail.asp?dpbID=3','','','');
oM.makeMenu('m583','m537','Bond Symbols','info/productDetail.asp?dpbID=4','','','');
oM.makeMenu('m538','m513','Halts & Imbalances','mdx/','','','');
oM.makeMenu('m515','','Documentation','','','','') ;
oM.makeMenu('m592','m515','Contracts','info/vendorcontracts.asp','','','');
oM.makeMenu('m593','m515','Notices','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmCTANotices?readform&Start=1&Count=10','','','') ;
oM.makeMenu('m594','m515','Policies','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmPolicies?readform&Start=1&Count=10','','','');
oM.makeMenu('m595','m515','Pricing','','','','');
oM.makeMenu('m599','m595','CTCQ','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmRateSchedules?readform&Start=1&Count=10','','', '');
oM.makeMenu('m600','m595','PDP','info/priceList.asp','','','');
oM.makeMenu('m596','m515','Procedures','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmProcedures?readform&Start=1&Count=10','','','') ;
oM.makeMenu('m516','','Vendor Services','','','','');
oM.makeMenu('m601','m516','Become a vendor','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmVendorApp?openform','','','');
oM.makeMenu('m602','m516','Contracts','http://mds.nysedata.com/efpdata/MDS/MarketDataHome.nsf/frmAgreements?readform','','','');
oM.makeMenu('m603','m516','Datafeed Request','https://mds2.nysedata.com/efpdata/MDS/DataFeedRequestApp/DataFeedRequests.nsf/frmVendorsHome?readform&Start=1&Count=30','','','' );
oM.makeMenu('m604','m516','Reporting','https://mds.nysedata.com/mdsdata/vendorreporting/vendorreporting2.nsf/vwstartapp/$first?opendocument&V=&P=mdrptlogin.html','','','' );
oM.makeMenu('m517','','Customer Service','','','','');
oM.makeMenu('m609','m517','Billing Issues','mds/default.asp','','','');
oM.makeMenu('m610','m517','Other','info/helpCenter.asp','','','');
oM.makeMenu('m518','','Help','','','','');
oM.makeMenu('m612','m518','Complaints and Inquiries','mds/default.asp','','','33');
oM.makeMenu('m613','m518','FAQs','info/helpCenter.asp','','','');
oM.makeMenu('m614','m518','Product Info','info/productList.asp','','','');
oM.makeMenu('m615','m518','Technical Issue','info/contactus.asp?subjID=2','','','');
oM.makeMenu('m616','m518','Business Issue','info/contactus.asp?subjID=5','','','');
oM.makeMenu('m617','m518','Billing','','','','');
oM.makeMenu('m625','m617','PDP','info/contactus.asp?subjID=3','','','');
oM.makeMenu('m626','m617','CTCQ','mds/default.asp','','','');
oM.makeMenu('m618','m518','Website Comments','info/contactus.asp?subjID=6','','','');
oM.construct(); /*Create the menus*/
</script></td>
    <td width="10"> </td>
    <td align="center" width="615" valign="top">

      <table border="0" cellpadding="3" cellspacing="0" width="615">
        <tr>
          <td width="615" class="pageTitle">TAQ Web</td>
        </tr>
        <tr>
         <td width="615" height="5"></td>
        </tr>
        <!--<tr>
          <td>
            <map id="mymap" name="mymap">
               <area shape="rect" coords="138,2,207,31" href="./queries/makeQuery10b.asp">
            </map>
            <img src="../images/Tabs-TradesQuotes.gif" width="614" height="32" alt="Trades/Quotes" border="0" usemap="#mymap">
          </td>
        </tr>-->
        <tr><td><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td width="5" nowrap background="/images/tab_start_stop.gif"></td><td width="24"><img src="/images/tab_left_whi.gif"></td><td nowrap background="/images/tab_back_whi.gif" align="center" class="tabMenus">Trades</td><td width="24"><img src="/images/tab_whi_o_blu.gif"></td><td nowrap background="/images/tab_back_blu.gif" align="center" bgcolor="#E7EDF9" class="tabMenus"><a class="tabMenus" href="/queries/makeQuery10b.asp">Quotes</a></td><td width="24"><img src="/images/tab_right_blu.gif"></td><td width="100%" align="right" background="/images/tab_start_stop.gif"></td></tr></table></td></tr>

      </table>
       <form name="formMakeQuery" method="post" action="queries/queryresults10a.asp">
      <table border="0" cellpadding="1" cellspacing="0" width="550" align="center">
        <tr>
          <td class="viewColElement2"> </td>
         <td class="viewColElement3"><a href="javascript:doOpenWin('help');">Help?</a></td>
        </tr>
      </table>
      <table border="0" cellpadding="3" cellspacing="0" align="center">
        <tr>
          <td class="viewFieldName">Symbol:</td>
          <td class="viewColElement2"><input type="text" name="querySymbol" maxlength="10" size="15" value=""> <input type=button value="Look Up" title="Look Up Symbol" class="dbutton" name="symbolLookUp" onClick="doOpenWin('symbol');"></td>
        </tr>
        <tr>
          <td class="viewFieldName">Date:</td>
         <td class="viewColElement2"><input type="text" name="queryDate" maxlength="10" size="15" value="10/3/2003"> <a href="javascript:show_calendar('formMakeQuery.quer yDate');"><img border="0" src="images/calendar.gif" width="23" height="18"></a></td>
        </tr>
        <tr>
          <td class="viewFieldName">Time Begin (hh:mm):</td>
         <td class="viewColElement2"><input type="text" name="queryTimeBegin" maxlength="5" size="10" value="8:00"> <select name="beginAMPM" size="1"><option value="am" selected>AM</option><option value="pm" >PM</option></select></td>
        </tr>
        <tr>
          <td class="viewFieldName">Time End (hh:mm):</td>
         <td class="viewColElement2"><input type="text" name="queryTimeEnd" maxlength="5" size="10" value="7:00"> <select name="endAMPM" size="1"><option value="am" >AM</option><option value="pm" selected>PM</option></select></td>
        </tr>
        <tr>
         <td class="viewFieldName" valign="top">Exchange:</td>
         <td class="viewColElement2">
           <table border="0" cellpadding="0" cellspacing="0" align="left">
             <tr>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="N" checked>NYSE</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="W" checked>CBOE</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="P" checked>Pacific</td>
            </tr>
            <tr>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="A" checked>AMEX</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="M" checked>Chicago</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="T" checked>NASDAQ</td>
            </tr>
            <tr>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="B" checked>Boston</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="C" checked>Cinn</td>
               <td class="viewColElement2"><input type="checkbox" name="queryExchange" value="X" checked>Phili</td>
            </tr>
           </table>
         </td>
        </tr>
      </table>
      <table border="0" cellpadding="3" cellspacing="0" align="center">
            <tr height="20"><td width="160"></td></tr>
         <tr>
           <td align="right" width="176"><input type="button" name="cancel" value="Cancel" class="dbutton1" title="Cancel" onclick="window.location.href='../currentData.asp'"></td>
           <td align="center" width="259"><input type="button" name="submitIt" value="Submit" class="dbutton1" title="Submit" onclick="doSubmit(document.formMakeQuery);"></td>
         </tr>
            <tr height="10"><td width="160"></td></tr>
      </table>
      </form>

    </td>
  </tr>
</table>
<table border="0" width="760" cellspacing="0" cellpadding="0">
  <tr>
    <td width="145" class="footer"> </td>
    <td height="30"></td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td></td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td align="center" class="footer">© 2003 NYSE Inc. All Rights Reserved
      - <a href="privacy.asp">Privacy</a> - <a href="legalese.asp">Conditions of Use</a></td>
  </tr>
  <tr>
    <td width="145" class="footer"> </td>
    <td align="center" class="footer"> </td>
  </tr>
</table>

</body>
</html>


 
Old October 6th, 2003, 04:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

check out http://www.greggriffiths.org/webdev/both/excel/





Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from excel darkhalf Access 5 February 14th, 2008 11:48 AM
how to import excel data into sql server khaink ASP.NET 1.0 and 1.1 Basics 1 July 31st, 2007 09:10 PM
How can we import the data from Ms Excel balesh ASP.NET 1.0 and 1.1 Professional 1 June 8th, 2006 02:15 PM
Import Excel data into a workbook Derek_05 Excel VBA 5 May 31st, 2006 02:02 PM
Excel Data Import bmains ASP.NET 1.x and 2.0 Application Design 4 April 14th, 2004 02:12 PM





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