Skip to main content
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:

 

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

 

Kind Regards,

Ashwin A.K


Reply