I have data stored in a flat file with comma or semicolon as delimiter.... I want to FTP this data directly into an excel sheet on my desktop without any manual intervention.
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
Hi,
'am not very sure that what you trying to do can be done without any manual intervention, however, You may like to have a look on this current similar topic:
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: 6250 Location: Mumbai, India
Hi,
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.