My searching is only turning up convertor tools or ways to do it from Excel and not Access but even what I found there wasn't quite what I am after.
I am trying to replicate what Acrobat does when you do Save As and choose .xlsx as the file format. It takes the PDF and converts it to a single sheet Excel file which I can then work with as far as bring the data I am after into Access (I would prefer to keep it to one worksheet). Could anyone possibly point me in the right direction on this? I cant find anything to reference to even know where to start.
I have Acrobat 2016 and access to all its libraries.
I am trying to replicate what Acrobat does when you do Save As and choose .xlsx as the file format. It takes the PDF and converts it to a single sheet Excel file which I can then work with as far as bring the data I am after into Access (I would prefer to keep it to one worksheet). Could anyone possibly point me in the right direction on this? I cant find anything to reference to even know where to start.
I have Acrobat 2016 and access to all its libraries.