Exporting Data From Siebel And Saving In Csv Format (Doc ID 1494454.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Siebel Tools - Version 8.1.1.2 SIA[21215] and later
Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
***Checked for relevance on 28-Feb-2014***
*** Checked for relevance on 05-May-2016 ***

Goal

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"
ExcelApp.SaveAs(sfilename)
ExcelApp.Application.Quit
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms