Help me please
I have an evaluation copy of Advanced Spreadsheet Pro and I am finding that we cannot create transformations which import data from one spreadsheet and then export to another spreadsheet.
In principle, the transformation that I have created works just fine, as I can import from Excel and then export the data to a comma delimited flat file. However, the moment that I change the 'write' object to Excel spreadsheet, I start to get access violations,etc. When I subsequently 'run' the transformation, the whole of the ETL Processor hangs irretrievably.
I have created two totally different connection objects for the Excel 'import' and the Excel 'export'.
Maybe, behind the scenes, the system is using the same instantiation of the Excel ODBC connection and this is having problems supporting connections to more than one sheet?
Regards Steve
