Can someone please help me to understand how we can insert the Data Table to Microsoft Access Data base.
The connection to the Microsoft Access DB File is Successful and used Insert activity, which throwing following error.
Insert: Syntax error in FROM clause.
Buddy kindly check if any column name in the datatable ClaimDT is with gap in between their columnname like First Name…it should be First_Name or FirstName…if so kindly remove those gaps as we cannot create a table with table name having space in db…
Kindly enclose the both the tables TBL MEDICAL CLAIMS and ClaimDT with square brackets like this
“[TBL MEDICAL CLAIMS]”
.Moreover kindly check once whether the columns are in order as such in db
They should match exactly
Cheers buddy hope this would help you
Much appreciated for your kind explanation @Palaniyappan .
It’s really helped.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.