Is it possible to build a bot to go from excel into an access database? And if so would it be necessary to load into tables or the data entry form?

Hi @dean mcghee​ ,

You have the option of reading a sheet into a Datatable using the Excel Advanced: Get Sheet as Data Table

After that, you can establish a connection with the Database and then loop for each row in Table and Insert it like so:

Could you try and see if that works out for you?

Kind Regards,

Ashwin A.K