1
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
how can i import data from excel to oracle 9i?
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
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 [...]
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
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 [...]
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
How can i print the output of the Visual basic progam on excel sheets?
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
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
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
I have data in rows in a note pad without separators. How to convert these into columns in a excel file
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
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
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
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 .
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
Hi, Could you please help me to get informations from other applications to excel using 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 can I export crystal report to an excel file
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
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), [...]
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
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.
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
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.
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
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,
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 export visual basic6 to excel file
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 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
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
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav
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
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)
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
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
1





