Question

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?

  • 28 January 2022
  • 1 reply
  • 9 views

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?

1 reply

Userlevel 3
Badge +7

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