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:
This might be the lightest and modern way to use C# to populate your SQL table.