I already have a pdf form (product list) connected with an access database, but I'm looking for an automated solution, because the product list is updated very often, and I don't want to manually copy the data every time I update.
I connected an Excel to Microsoft Access and got a table that updates automatically when changes are made in Excel, only that when I replace the new database, it no longer displays any products in the product list.
I connected the new database, with the column names identical to the old ones.
Are these answers useful? Help other community members by marking useful answers as accepted.