M
Martin
It sounds like you are redesigning a table each month.
You could create separate tables each containing one of
the file layouts. Import the excel files to the
appropriate table that fits the layout.
To create the upload file for your AS400, use a report to
organize the data into the required format and export the
results to a text file.
Hope this helps.
You could create separate tables each containing one of
the file layouts. Import the excel files to the
appropriate table that fits the layout.
To create the upload file for your AS400, use a report to
organize the data into the required format and export the
results to a text file.
Hope this helps.