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?
Page 1 / 1
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.