Exporting Data From Siebel And Saving In Csv Format
(Doc ID 1494454.1)
Last updated on APRIL 04, 2021
Applies to:Siebel Tools - Version 220.127.116.11 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 ***
*** Checked for relevance on 01-MAR-2019 ***
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"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document