S
Shawn Johnson
I have an ERP system that we are converting over to a non-compatible system
(aren't they always?). Basically, we are a manufacturing site with product
formulations, qc specifications, etc.
Because the systems are incompatible with each other, and only certain
pieces of data can be migrated over, I am trying to come up with a solution
to give us what we need and save us manual input time.
In a nutshell, I can connect to our system through ODBC and generate a
Access report that will basically show us our product formulas with
associated QC specifications for testing. I have done this already,
everything works, and I can generate a complete report by formula of the
ingredients as well as any testing information.
The problem is this... in a perfect world, I'd just dump this report out for
archival purposes and be done with it. Unfortunately, when we loose our old
system, we will loose our ability to do go back.
The plan right now is to create a separate Excel spreadsheet for each one of
our products and regurgitate the information I generated in the report. The
reason for choosing Excel is that it is formattable, they can edit the data
at some point in time, we can create a template, and everyone has and uses
it. Though this approach will work, I am hoping there is a better way to do
it.
What I would like to do is to take my existing report and export it to
Excel. I know I can do this already. But the catch is that I'd like to have
a separate Excel file automatically created for each product. Is there any
way to force a file to be created for each change in product formula?
(aren't they always?). Basically, we are a manufacturing site with product
formulations, qc specifications, etc.
Because the systems are incompatible with each other, and only certain
pieces of data can be migrated over, I am trying to come up with a solution
to give us what we need and save us manual input time.
In a nutshell, I can connect to our system through ODBC and generate a
Access report that will basically show us our product formulas with
associated QC specifications for testing. I have done this already,
everything works, and I can generate a complete report by formula of the
ingredients as well as any testing information.
The problem is this... in a perfect world, I'd just dump this report out for
archival purposes and be done with it. Unfortunately, when we loose our old
system, we will loose our ability to do go back.
The plan right now is to create a separate Excel spreadsheet for each one of
our products and regurgitate the information I generated in the report. The
reason for choosing Excel is that it is formattable, they can edit the data
at some point in time, we can create a template, and everyone has and uses
it. Though this approach will work, I am hoping there is a better way to do
it.
What I would like to do is to take my existing report and export it to
Excel. I know I can do this already. But the catch is that I'd like to have
a separate Excel file automatically created for each product. Is there any
way to force a file to be created for each change in product formula?