MS Access Database Not Updating

[Christopher McGee]

Hello -
I created a Task to pull information from a Program and input it into aMS Access Database. The Task seems to Run fine, but the Information is not appearing in the MS Access Database. Not sure whats happening, below is the SQL Statment I'm Using. Any help would be appreciated.

SQL Statement Used:
INSERT INTO Store Cameras [(region[, district[, store_name[, camera_name])
VALUES [($StoreRegion$[, $StoreDistrict$[, $StoreName$[, $my-list-variable$)]

Thanks,

[forumsupport]

Hello,

Your Insert query should be,

INSERT INTO Store Cameras (region, district, store_name, camera_name)
VALUES ($StoreRegion$, $StoreDistrict$, $StoreName$, $my-list-variable$)

You can also refer an online sample task for Migrating data from Excel to Database at,

Migrate Data from Excel to Database - Automation Anywhere. The Automation Software.

Note: Please ensure that you are using this Insert query with 'Insert/Update/Delete' option of Database command and not with the 'SQL Query' option.

Hope that helps.