import from excel to oracle 9i
how can i import data from excel to oracle 9i?

Answer Question   |  September 4, 2009  7:45 AM
Microsoft Excel, Microsoft Excel import/export, Oracle 9i, Oracle 9i import/export

CPYTOIMPF
CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF(‘C:/Documents and Settings/user/exc.xls’) MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created a Excel book with name exc.xls , my requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired excel book. when i run this command I am getting message zero records are copied . Could u suggest me [...]

Answer Question   |  July 10, 2009  6:58 AM
Copy To Import File, CPYTOIMPF, Microsoft Excel import/export, Physical File

How to create iSeries printer file width greater than 378 limit?
Is it possible to create an iSeries spooled printer file with a width greater than the 378 character limit on the CRTPRTF command? Possibly using an AFP function? The spooled file is intended to be imported into the COMPLEO utility for conversion to EXCEL. There is no need to print the spooled file. We are [...]

Answer Question   |  November 27, 2009  8:47 PM
AS/400 Printer File, AS/400 printing, CRTPRTF, iSeries, iSeries import/export, iSeries printing, Microsoft Excel import/export, Printer files, Symtrax Compleo

Printing VB results on Excel sheet
How can i print the output of the Visual basic progam on excel sheets?

Answer Question   |  June 23, 2009  11:20 AM
Microsoft Excel import/export, Visual Basic

Microsoft Excel to mainframe
i need to pick instalment nos from excel & put them into a maiframe application & then access the details of that installment from mainframe after pressin the enter key but this needs to be done using vb script

Answer Question   |  June 15, 2009  7:52 AM
Mainframe, Microsoft Excel import/export

Conversion of text file from Notepad to Microsoft Excel
I have data in rows in a note pad without separators. How to convert these into columns in a excel file

Answer Question   |  June 10, 2009  10:48 AM
File conversion, Microsoft Excel import/export, Notepad

Export SSRS Report to Microsoft Excel
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

Answer Question   |  June 10, 2009  4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS

How can I export data from mainframe to Excel in REXX
i want to export data in PS to excel through rexx code.As i am a beginner in REXX .can any one help me in this .

Answer Question   |  August 12, 2011  6:13 AM
Mainframe, Microsoft Excel, Microsoft Excel import/export, REXX, REXX Procedure, REXX procedure to export data to Excel

Microsoft Excel macro to access other applications
Hi, Could you please help me to get informations from other applications to excel using macros?

Answer Question   |  April 28, 2009  8:38 AM
Exchange 2000, Microsoft Excel, Microsoft Excel import/export, Microsoft Excel macros

Export Crystal Reports to Microsoft Excel format
how can I export crystal report to an excel file

Answer Question   |  August 21, 2010  12:10 AM
Crystal Reports, Crystal Reports import/export, Microsoft Excel, Microsoft Excel import/export

How to create procedure in Oracle
I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID VARCHAR2(40) NOT NULL, CLUSTER_CODE VARCHAR2(15) NOT NULL, TOWN VARCHAR2(50), [...]

Answer Question   |  July 30, 2009  12:28 PM
Microsoft Excel import/export, Oracle development, Oracle import/export

Excel 2003 docs now won’t open in Excel 2007
I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.

Answer Question   |  December 29, 2011  10:56 PM
Excel 2003, Excel 2007, Legacy applications, Microsoft Excel import/export

How to export data from AS/400 into Microsoft Excel
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.

Answer Question   |  January 26, 2009  7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export

CL Program
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,

Answer Question   |  January 9, 2009  7:57 PM
AS/400 import/export, AS/400 queries, CL programming, Exporting AS/400 to Excel, Microsoft Excel, Microsoft Excel import/export

Export from Visual Basic 6 to Microsoft Excel file
how to export visual basic6 to excel file

Answer Question   |  April 7, 2010  1:54 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, VB 6, Visual Basic, Visual Basic 6

How to call Microsoft Excel from Oracle Reports/Forms 6i
how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

Answer Question   |  November 21, 2010  10:55 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports

How to upload data from Excel into SQL Server 2005
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

Answer Question   |  November 25, 2008  12:59 PM
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export

Export from database to Excel and filter by DropDownList
please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

Answer Question   |  November 11, 2008  11:33 AM
Active Server Pages, ASP.NET, Database import/export, DropDownList, Microsoft Excel, Microsoft Excel import/export

Microsoft Access export to Excel changes values
I have a table populated through a form using lookup tables. When this table is exported using “right click,export” to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

Answer Question   |  August 20, 2008  10:04 PM
Microsoft Access import/export, Microsoft Excel, Microsoft Excel import/export