Posting Yak Master
Posted - 02/18/2014 : 02:30:06
| Hello there,
I am facing a issue in importing CSV file to my MS SQL Table.
Let me explain my problem:
I have 2 tables:- 1# Stock_Symbol 2# Stock_Symbol_Daily_Quotes
In Stock_Symbol there are 2 columns - Stock_ID & Stock_Name
In Stock_Symbol_Daily_Quotes there are ID; Stock_ID; Price; Time; Date; High; Low; etc.
From the following link - http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr I am manually can get any stock information as CSV.
But I want to do this automatically and directly to Stock_Symbol_Daily_Quotes table. I am seeking for some T-SQL which will allow me to download the stock price in every 15 minutes.
BBDB.TO+NT.TO+GE+MSFT - this will come directly from Stock_Symbol table.
Is there a way to do that, I tried lot of option, I know if the csv file located locally I can do the import and doing dynamically and directly from web is what I am not able to do that.
Hope I am able to make you understand my query, please help me.
Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F
Edited by - daipayan on 02/19/2014 01:10:32