Exporting Data From Siebel And Saving In Csv Format
Last updated on SEPTEMBER 12, 2017
Applies to:Siebel Tools - Version 22.214.171.124 SIA and later
Siebel CRM - Version 8.1.1  and later
Information in this document applies to any platform.
***Checked for relevance on 28-Feb-2014***
*** Checked for relevance on 05-May-2016 ***
Customer was trying to export data from siebel through VB Script and saving in "csv" format. The saved file type showed as "Microsoft Excel Comma seperated Values File". When tried to open in xls, the data was displayed correctly. But when they open in notepad, it displayed the data in unreadble format. Even though the file format shows csv, it was getting saved as xls.
How to save the file in csv format? Below is the sample code for excel intialization and SaveAs.
Set ExcelApp = CreateObject("Excel.Sheet")
ExcelApp.Application.Visible = 1
strEnv = Environ$("SIEBEL_ROOT")
sfilename = strEnv &"\OUTPUT\AccountExport_"& Format$(Now(),"mmddyy") &".csv"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms