Q & A on what is the best way to stream Excel data into SQL database table with DotNet CSharp?

(Last Updated On: March 12, 2014)

Q & A on what is the best way to stream Excel data into SQL database table with DotNet CSharp?Answers below:
> Hi Bryan,
>
> Your cswatcher is watching csv file, can you suggest direction for
> watching excel file?

–> I am using now  *** for  Excel which does streaming withj IQFeed or IB

Is it good to convert excel file to csv then
> import into sql?

–> You could easily export the Excel into SQL via C#

Can SSIS watch excel file and streaming changed data
> into new record in sql table? What is the best way?

–> I have never used SSIS but this might be a decent option. I currently wrote a pair trading C# application which build Excel worksheets using the legacy Interop API. it is very slow and not recommended. I have also seen this as well for Office 2013:
http://msdn.microsoft.com/en-us/library/bb448854(v=office.14).aspx
This might be the lightest and modern way to use C# to populate your SQL table.

Join my FREE newsletter to learn more about .NET

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
This entry was posted in Featured, Quant Development and tagged , , , , , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs