Microsoft Access DB

Help
#1

Hi Everyone,

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.

Capture1
Capture2

#2

Hi @winningvish.
Have you tried consulting this documentation?

Thanks and regards.

#3

Some of the issues I encoutered were:

  1. Wrong datatypes between dt column and access field
  2. Access column names with protected words
  3. Characters in the dt values that were not allowed in Access
#4

Hi Jan

Thank you very much for your kind reply.

I have referred that document.

Table Names is “TBL MEDICAL CLAIMS” which is in Access DB
Data Table is ClaimDT generated from the workflow.

Regards
Vishnu

1 Like
#5

Thank you @MatthiasVG. Is the problem resolved ?

Regards
Vishnu

#6

@winningvish

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]"
[ClaimDT]

.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