I had a MS Access script written 1 year ago, that would take the excel file, import the data, arrange data in specific order and calculate the numbers.
This would be displayed in a Report layout that is then saved as a PDF in a FileOutput directory.
Currently the import process works, not all the time now but I can provide the actually MS Access file with all this inside it.
My issue is mostly in not being able to PRINT the Reports as PDFs. This script worked for the last year or so with almost no problems. So I'm not sure why the PDFs will not print out now like they used too.
If you are a pro with MS Access this should be easy to correct or fix the PDF creation error.
I can provide;
The original MS Access file used to import the data from an Excel file.
Sample Excel file with the data used by MS Access to populate the report.
The report and layout are all in MS Access.
Problem to Solve = Help improve the import process and the PDF creation part of the Reports.
currently this setup was made to work with MS Access 2007 and Excel 2007. I have also download and installed the Add-on file that saves as PDF plugin for MS Excel 2007
Thanks, send me a Private Message with any questions you might have.