My Oracle Support Banner

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

Last updated on DECEMBER 07, 2022

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. ***   ***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

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.