How do I get a PDF report into Excel

JAYA123 can’t do this. You have three options.

a) Buy Adobe Acrobat and use it’s import/export facility.

b) Buy and use one of the many PDF to xxx (Excel, Word, etc.) converters that
are on the market. Most are pretty cheap. Do a Google search on “pdf to
excel” and there will be all sorts of links. Here are three

http://www.library.mcgill.ca/edrs/services/publications/howto/PDFtoXLS/

PDFtoExcel.html

http://www.colorpilot.com/index.html

http://www.investintech.com/able2extract.html

c) JAYA allows you to download ALL of your data for back-up or for your own
minipulation. See the Utility menu for this. However, there is no selection
criteria. You get ALL your data…. in either comma-delim text files or in
what is known as sql-dump format. In order to get the data you want into
Excel it would be best to first set up a small database in Access and then do
a “join” query to get what you need into one table and export that to Excel.
Obviously, you need to know what you are doing…. i.e. have some database
experience… in order to do any of this. While any trained IT person could
do this with their eyes closed, it’s not exactly a simple task for the
average user. Thus, perhaps you want to employ a contract programmer to do
some of this for you. In SF be prepared to pay around $75 an hour, if not
more…. however, you might get a college student to intern for you. We’ll be
glad to answer specific questions from a knowledgeable person to help them…
but it way beyond our terms of service to walk the average user through what
is a somewhat complex process.

Let me quickly explain why this is difficult… and it’s not a function of
JAYA… it’s a function of how modern databases are constructed. All records
are kept in tables that are linked by a common key. We have Customer records.
Each Customer record has many Order records. Each Order record is linked to
many Detail records. Each Detail (item sold) record is linked to a Product
record…. each Product record is linked to an Author/Vendor record. What it
all boils down to is that inorder to do all the fancy extract, sort, and
reporting on data, we “sacrifice” simplicity. You can’t have it two ways….
the ability to extract all people who line in NY on a street with “elm” in
the name, who bought Gone With The Wind, between two dates….. AND have a
simple and easy database structure. Just can’t be done.