Thanks for your response. But as I said there should no manual intervention in creating that excel.(This means that the excel should automatically be created based on the data from the dataset and it should identify that the comma or semicolon is the delimter)
Do let me know if you have any further suggestions/comments to add....
Joined: 22 Apr 2006 Posts: 6258 Location: Mumbai, India
No, Excel files are not mainframe compatible, so you can not do it the way you are asking - instead You can create a comma or tab delimited text file or a HTML file, transfer that to your PC and import into Excel.
Recorded a macro to import and format procedure for the three files, save those formatted files as excel files, saved the macro in an excel sheet and set that Macro to execute on opening this excel file.
Wrote a DOS Batch to ftp the files and automatically open this excel file.
Now i just double click the DOS Batch file, it downloads, formats the downloaded text file and saves it as excel file. This is saving more than an hour for me daily.