As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
WebFOCUS/ReportCaster sends Excel spreadsheets as type 'webpage' instead of type 'normal' when I choose the format EXL2K or EXL97. Is there a way to have it sent as type 'normal'. (XLnormal). Types of 'XLwebpage' do not allow for importing to Access Database. They must be opened and "saved as" type 'XLnormal' before they can be imported to Access database.
I have to schedule a job which will ftp the excel output file to a remote location.From there, an automated program runs and will import into Access database. So I can not do the manual step here to do 'Save as' of normal excel file tyle.
No, they only want a file which has extension '.xls'. I am just trying to see if it is possible or I have to ask my client to see if they can accept csv file. But, before that I am just wondering if we have any excel format which saves as the normal type. I tried the format 'EXCEL' and it saves as excel 2.0, which is not accepted in Access database.
You might be able to hold the file as COMMT or TABT and rename it to have the .xls extension.
We do this all the time with tab-delimited data. Double-clicking on the filename.xls icon opens the file just as though its internal format were Excel.
Don't know whether Access is as smart as Excel in this respect.
Posts: 124 | Location: Lebanon, New Hampshire | Registered: April 24, 2003
If caster and the reporting server are on the same box, you might also be able to have 2 seperate jobs when 1 runs after the other. the first one runs and creates an access database. The 2nd run and send the a file (the access database).
Focal Point Forums 