Insert record from Data Table to Access

[arthurang]

Good morning everyone

OBJECTIVE: i would like to insert all record from my data table to access
DATA TABLE: dt_Original_Table (RefNum, DateCreated, Type, Category, Amount)
ACCESS TABLE: TEST (RefNum,DateCreated, Type, Category, Amount)

NOTE: All record in dt_Original_Table came from excel file (all data type is string if i’m no mistaken).

QUESTION: how can i insert record from data table to access. with access data type perspective. like if the DateCreated column in dt_Original_Table is String and auomatically converted as Date/TIme in access.

[Manish540 (Manish Shettigar)]

Hi @arthurang ,

Check this below link,

MS Access Error while inserting data into database from UiPath

Hi All I am trying to do MS Access database connectivity using UiPath, but getting the error "Execute query: Cannot open action query ‘’. Please find below the connection string, query used and table details. Connection String: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=“C:\Users\ABC\Documents\UiPath\ANZ_CMD_Legal\ANZ CMD Legal.mdb” Insert query: “INSERT Into [ContactDetails] (Name, Country, Address, City, State, PostCode, Email) Values (@Name, @Country, @Address, @City, @State, @PostCode,…

Insert Data from DataTable to MS Access Table in UiPath | Insert Bulk Data in MS Access in UiPath

Hope this may help you