Hi,
I am just taking a chance as Excel (and the lounge guru's) have more than a few times surprised me with answers that I thought cannot be done!
So...here goes:
I have a list of info that was exported from SAP (ERP) into a PDF file format. Is there any way that this PDF can be open / imported into Excel. I have tried a number of ways without success, even opening Acrobat Reader and saving the list as text. Then importing the text file into Excel, but it is a mess as one cannot save with delimiter or as fixed width.
Any ideas?? (Try and surprise me - )
TIA
Import PDF into Excel
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Import PDF into Excel
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Import PDF into Excel
PowerPoint MVP Stephen Rindsberg has written
A Google search for convert pdf excel will turn up lots of tools, but I have no experience with any of them.
I'd ask for an export directly to Excel, or to a .csv file.
More or less the same holds for converting PDF to Excel.Converting a PPT to a PDF is like turning meat, veggies, spices and water into stew. Pretty simple.
Converting a PDF to a PPT is like turning stew back into the original meat, veggies, spices and water. Darn near impossible.
A Google search for convert pdf excel will turn up lots of tools, but I have no experience with any of them.
I'd ask for an export directly to Excel, or to a .csv file.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Import PDF into Excel
HansV wrote:PowerPoint MVP Stephen Rindsberg has writtenMore or less the same holds for converting PDF to Excel.Converting a PPT to a PDF is like turning meat, veggies, spices and water into stew. Pretty simple.
Converting a PDF to a PPT is like turning stew back into the original meat, veggies, spices and water. Darn near impossible.
That is a pretty darn good quote! I thought I had a glimmer of hope when I managed to get the meat back on the bone (and some of the onions back together again), but it all pretty much fell apart again after...so guess what...I just ate the stew anyways...and it was good!
Thanks for that mouth watering confirmation Hans
...I think I'll go have something to eat now!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.