Create Excel format files from all exception tables
Posted: Wed Jan 23, 2008 7:39 am
We want to store the exception tables (generated while running the Datafilters in AuditStage) in excel or csv format preferably as readonly, reason we want to archive these exception tables (so they cannot be changed anymore) and we want to be able to explore the content of these tables using Excel filters.
In our conversion process we have build a big number of filters (more than hundred) if on high level we find differences we have to check all details + we do need to store/archieve the filter results (auditing)
Please advise how to create a csv or excel format from these exception tables. Is there a standard solution executing a SQL script on all exception tables or can we perform a script including the exception tables where we want to create csv files from.
Workaround: using an ODBC connection in Excel we import the data in the exception table from the SQL database and delete the Update function and store the file in excel format.
We repeat the action x number of times, copy the full directory to the archieve location.
Regards and thanks for your help
In our conversion process we have build a big number of filters (more than hundred) if on high level we find differences we have to check all details + we do need to store/archieve the filter results (auditing)
Please advise how to create a csv or excel format from these exception tables. Is there a standard solution executing a SQL script on all exception tables or can we perform a script including the exception tables where we want to create csv files from.
Workaround: using an ODBC connection in Excel we import the data in the exception table from the SQL database and delete the Update function and store the file in excel format.
We repeat the action x number of times, copy the full directory to the archieve location.
Regards and thanks for your help