sal21
09-15-2005, 05:44 AM
how to import stockquote/ticker price directly into a access table, also
if with throu excel or an excel interfcae?
if with throu excel or an excel interfcae?
|
View Full Version : import stockquote/ticker price .... sal21 09-15-2005, 05:44 AM how to import stockquote/ticker price directly into a access table, also if with throu excel or an excel interfcae? ScottGem 09-15-2005, 11:27 AM depends on the format of the quote file sal21 09-16-2005, 05:20 AM Hi Scott, tks for fast reply.... First i am a newbie in access;-( Second i am Napolitan, and a pizza for you, is garanted:-) See http://www.capitalmarket.com/bulletin/bsebhav.asp Here is many page A, B, C, D ecc... cicling each page from A to Z and get value from the web table. Insert into a access table all value... The name of the field are the header of table web and get all value... ScottGem 09-16-2005, 06:28 AM This still doesn't completely answer the question of format. Are you copying and pasting from that page, downloading a file or what? If you are doing a copy and paste, I would paste into Excel then link to the spreadsheet and append to my Access table. I would ignore the last 2 (52 Week) columns. In the Append I would assign the date. |