2
The problem here is, the database/report running software we use can not do certain things that we need (total by quarter/person/year, total for everyone for each one of those, etc.) so we have to export it to a PDF and then to an excel Document to get the numbers we need and in a report format that we are able to send to our clients.
What happens however, is these reports are 10-50 pages long, and the format does not work well in excel. I've tried to convert the PDF to text and then import it that way, but because of the numbers and the like, the format does not work at all.
Is there any simple way to bring all of this data in, in a clean format and then deliminate it so that it's easily worked with excel?
so your original data are in a database? Which type of database is it? All decent databases support to export query results into CSV (comma separated values) ASCII text files, which themselves are easily imported into Excel again. I don't understand your detour to PDF. It is a non-trivial undertaking to get a clean, error-free conversion of PDF contents into Excel. – Kurt Pfeifle – 2010-09-21T11:43:52.533
See, the problem is that we use MvQuery and Basys (both which are old and really not worth the time...but they still use them) and in MvQuery, we can generate a report from the data it pulls from Basys, however there is no way to export the finalized data in anything but a .PDF.
The original data needs finalized, or it's just a mash up of values. – AgainstClint – 2010-09-21T17:01:40.600
How is the pdf export setup? Obviously a query is happening to pull the data, then writing it to pdf format. So you can query your data in some other way. – datatoo – 2010-09-30T15:55:47.843
MvQuery is supposed to be able to export to excel directly, can you edit a copy of the report and change the output? – datatoo – 2010-09-30T16:10:02.513