Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daipayan
Posting Yak Master
181 Posts |
 Posted - 2014-02-18 : 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_QuotesIn Stock_Symbol there are 2 columns - Stock_ID & Stock_NameIn 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.Regards,DaipayanSoftware Analyst
Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F |
|
|
|
|
|
Auto Import Stock from Yahoo Finance to MS SQL