Hey all, I'm rapidly running out of ideas as to help with this one, Basically I have 2 excel documents that contain data that needs to be shipped off external sources. What I'm doing at the moment is using PDF wizard to generate PDF's of the specific parts of the excel documents I want to send and then emailing them out.
What I would like to do is develop something, either in access, filemaker or whatever that I can click and import the excel document into have it split up the relevant data and then email the result out to the people who need specific data.
1. Design a set of database tables based on the excel spreadsheets called the operational data store 2. Import the excel spreadsheets into two large tables in Access called the source data 3. Extract the source data using queries into the operational data store 4. Query the operational data store to generate the reports you need to send out as PDFs.
I would say Certus's method is pretty well a standard answer to this sort of thing (plus the odd fancy phrase like operational data store - was that some added value?). I can't see how doing this is oracle rather than access will make this simple and idiot proof unless you are much more familiar with Oracle.
In any event, the problem is the same irrespective of the tool (unless you are Pat).