Karen:
I’ve been very successful with “Monarch Desktop” from DataWatch Corp. ( starting w/ version 2.0 in 1993 ). Monarch allows you to ‘paint’ a data-capture mask on a native (1) PDF document. Each painted field is named and described, so as the capture proceeds the data is arranged in an internal format displayed very much like an Excel file. This data is then easily exported to Excel, CSV or SQL table structures. I believe the current version can be connected to the world through ODBC. Once created, any recurring document – such as a bank statement or financial statement – may be captured and converted using the mask. No need to recreate the mask. (1) Monarch works directly with data structures within a PDF document; it requires a PDF file generated directly with a PDF printing process. A PDF of a scanned hard-copy document is problematic. Let me know if I can help. Bruce Chitiea 909.238.9012 mobile From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, August 12, 2015 6:58 AM To: [email protected] Subject: [RBASE-L] - PDF to Excel Well, let's see if THIS message only comes to the list once!! Sorry for whatever hickup on my or their side that caused the cascading messages! Is there a utlity you've used to convert a PDF to Excel? I need to import data from a PDF file. I googled it and I see alot of "free" options (free is always cool) but I worry that those free utilities are installing other unknown things on the computer. Would be willing to pay for a quality program, of course! The utility doesn't have to be fully automated, the user is willing to do the conversion manually is that's required. Karen
