Microsoft Excel Import/export Questions and Answers

Recent IT Questions

1 - 19 of 19
<<PREVIOUS 1 NEXT>>

import from excel to oracle 9i

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

asked by Binty

  25 pts.

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

asked by Chrisjam

  95 pts.

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

View Answer   |  Jun 26 2009  8:47 PM GMT
iSeries, CRTPRTF, Symtrax Compleo
asked by Shuete

  25 pts.

Printing VB results on Excel sheet

How can i print the output of the Visual basic progam on excel sheets?

Answer Question   |  Jun 23 2009  11:20 AM GMT
Visual Basic, Microsoft Excel import/export
asked by Bhupiirari

  5 pts.

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   |  Jun 14 2009  7:52 AM GMT
Mainframe, Microsoft Excel import/export
asked by Kvm

  5 pts.

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

View Answer   |  Jun 10 2009  10:48 AM GMT
File conversion, Microsoft Excel import/export, Notepad
asked by Govind27

  5 pts.

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.

asked by AmitJoshi143

  10 pts.

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 .

asked by Laks143

  5 pts.

Microsoft Excel macro to access other applications

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

asked by Karthik12345

  5 pts.

Export Crystal Reports to Microsoft Excel format

how can I export crystal report to an excel file

asked by Yyt

  5 pts.

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

asked by VEERRELIANCE

  10 pts.

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.

View Answer   |  Mar 11 2009  10:56 PM GMT
Excel 2003, Excel 2007, Legacy applications
asked by Anniedun

  5 pts.

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.

asked by NADEE123

  5 pts.

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,

View Answer   |  Jan 8 2009  7:57 PM GMT
CL programming, AS/400 queries, AS/400 import/export
asked by Querys

  100 pts.

Export from Visual Basic 6 to Microsoft Excel file

how to export visual basic6 to excel file

View Answer   |  Dec 10 2008  1:54 AM GMT
Visual Basic, Microsoft Excel, Visual Basic 6
asked by Goood

  5 pts.

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

View Answer   |  Nov 26 2008  10:55 AM GMT
Oracle developers, Microsoft Excel, Oracle Reports
asked by Exporacle

  20 pts.

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

asked by Ambrish 82

  275 pts.

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   |  Nov 11 2008  11:33 AM GMT
ASP.NET, Active Server Pages, Microsoft Excel
asked by Yaz

  5 pts.

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

asked by Lsegura1212

  5 pts.

1 - 19 of 19
<<PREVIOUS 1 NEXT>>