Pasting Excel data into Access DB Table?

Help Something Else
1

I have an automation that retrieves data from Excel and my goal is to paste that data into an Access Database that is connected to a SharePoint list.

I am not allowed to install certain packages due to where I work (EG: UiPath Database Activities), so I am seeking help on how to to get the Data table that has been created from the excel data and paste this into an Access Table.

So far, I have the automation opening up the needed access DB and pasting data into it, but all that occurs is I get name of the data table pasting into the first cell within the access table.

Do I need to do a “for each row in datatable” to get each row of data into a new row within a variable, and then paste the resulting data?

2

@jon.whisman

If using ui you need to then you have an option to import excel as well i guess try to use that option

If not then you need to use for each and write each value

Cheers

3

@jon.whisman

*Read Excel File
*Establish a collection with DB using connect to database activity

*For each row in Datatable
use in Insert activity of database can insert each row into database

Cheers!!!

4

@jon.whisman

Check if you can install the Microsoft 365 activities package, then you can use Add List Item. activity to insert data into SharePoint directly.

Activities - SharePoint Lists activities (uipath.com)