<div>
Thanks, SRigney. &nbsp;But I already trashed this version because it worked without the Insert Into query. &nbsp;I was having other problems that prompted me to go this route. &nbsp;However, since you responded before I cancelled the question, I will give you the points. &nbsp;If you want more, just see my next question! &nbsp;;-)<br />
<br />
ptslv
</div>


Thanks, SRigney.  But I already trashed this version because it worked without the Insert Into query.  I was having other problems that prompted me to go this route.  However, since you responded before I cancelled the question, I will give you the points.  If you want more, just see my next question!  ;-)

ptslv

<div>
<div class="content wysiwyg-content">
I am trying to insert data into an Access database using C# in a Windows App. &nbsp;I keep getting a syntax error on this &nbsp;sql statement telling me a ';' is expected at the end of the statement. &nbsp;I put extra ; in and get the same error. &nbsp;All other surrounding code has the proper ';'. &nbsp;<br />
<br />
string strSQLSelect1 = &quot;INSERT INTO [Import] ([timeStamp], DocumentName, DocumentType, TransactionType,TANUM) &nbsp;&quot; +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;VALUES( &quot;&nbsp;+ @timeStamp, @DocumentName, @DocumentType, @TransactionType, @TANUM +&quot; )&quot;;<br />
<br />
ptslv
</div>
</div>


I am trying to insert data into an Access database using C# in a Windows App.  I keep getting a syntax error on this  sql statement telling me a ';' is expected at the end of the statement.  I put extra ; in and get the same error.  All other surrounding code has the proper ';'.  

string strSQLSelect1 = "INSERT INTO [Import] ([timeStamp], DocumentName, DocumentType, TransactionType,TANUM)  " +
	"VALUES( " + @timeStamp, @DocumentName, @DocumentType, @TransactionType, @TANUM +" )";

ptslv

Syntax Error in INSERT INTO Statement

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).