Microsoft Excel Import/export

import from excel to oracle 9i

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

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

Printing VB results on Excel sheet

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

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

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.

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 .

Microsoft Excel macro to access other applications

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

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

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.

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.

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,

Export from Visual Basic 6 to Microsoft Excel file

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

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

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)

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