<div>
Thanks Dan7el,<br />
apologies for delay in replying<br />
<br />
regards<br />
Pat
</div>


Thanks Dan7el,
apologies for delay in replying

regards
Pat

<div>
<div class="content wysiwyg-content">
I have a connection string to read from a SQL data base and another to read from an Excel spreadsheet. However how do I handle a situation where I want to read records from an excel spreadsheet and insert them into my SQL database<br />
<br />
example<br />
Insert into DCR_transaction_master &nbsp;SELECT * from [DCR_transaction_master$] where T2_transactionId='&amp;Transac<wbr />tionId'<br />
<br />
What connection string do I provide with this type of statement which is reading from Excel and writing to SQL DB?<br />
<br />
regards<br />
Pat
</div>
</div>


I have a connection string to read from a SQL data base and another to read from an Excel spreadsheet. However how do I handle a situation where I want to read records from an excel spreadsheet and insert them into my SQL database

example
Insert into DCR_transaction_master  SELECT * from [DCR_transaction_master$] where T2_transactionId='&TransactionId'

What connection string do I provide with this type of statement which is reading from Excel and writing to SQL DB?

regards
Pat

Connection strings for two different sources (Excel &amp; MS SQL)

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Connection strings for two different sources (Excel &amp; MS SQL)

Connection strings for two different sources (Excel & MS SQL)