I have an automation that retrieves an excel file, uses the UiPath.Database package to connect to an Access DB. This access DB is connected to a SharePoint list.
When the SharePoint records are inserted into the list, any columns containing spaces in the data do not get inserted.
I receive no errors in the automation at all, but how do I pass the data from the UiPath data table into MS Access so that columns with spaces are retained?
I have seen other posts in the forum about enclosing column names in ([column_name_here), but how do I do this in a data table?
-
I get the excel
-
do a “Read Range Workbook” into a datatable
-
Connect to Access file and access table
-
finally, use the insert activity to pass the data table from the read range workbook into the access table
-
The resulting entries in SharePoint have any column that had a space in column data showing as blank columns in the SharePoint list.