Recent content by pheffley

I have a DMP file that I need to import into my shcema. It was exported from an entirley different database/user. I get the following: Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0...

I have three tables that I am trying to join: Plan Oper Master_PDN The Plan & Oper tables are joined by Plan#; the Oper & Master_PDN are joined by PDN: Select a.RCC From Plan a where Plan# in (select b.Plan# from oper b, Master_PDN c where b.PDN = c.PDN)...

I have an Excel workbook that was designed to provide calculated data from 1-M worksheets based on the selection. All I see when I open this file is the menu screen where several radio buttons are grouped. Once one is selected and you click the calculate button, a formatted spreadsheet...

When I tried: LOAD DATA INFILE * INTO TABLE TEMP RECORDS TERMINATED BY NEWLINE FIELDS TERMINATED BY ',' BEGINDATA ####A,########AA,AAAAAAAA,AAAAA,A,AAAAA,AAAA,AAAAA It failed because it was expecting "(" after the 'INTO TABLE' statement. Also, how and where do you specify which...

I do have a quick question...If I use the standard SQL*Loader method (using a control file with data), how do I handle records that aren't terminated by anything? Would this (NEWLINE) work? If not, how is it handled? LOAD DATA INFILE * INTO TABLE TEMP RECORDS TERMINATED BY NEWLINE FIELDS...

I have a delimited text file that I need to bring into my database. In the past, I've used ETL tools, but I don't have access to those anymore. Can this be done through enterprise manager, SQL*Plus, Command Prompt? I just have a stand-alone version of 9i. Thanks, Paul

Like I said, I'm pretty green in Excel programming. Where would I input and run code like this? Thanks, Paul

Okay, cool. Do I have to do this manually for each sheet in each workbook, or is there an easier way? The reason I ask is because I'm dealing with over a Gig of data broken out in 27 excel workbooks each having 3 to 60 sheets. ;( That's a lot of copying/pasting! Also, Code1 and Code2 need to...

I'm pretty green in Excel programming. How exactly would I accomplish the above. Also that takes care of splitting the Part Nbr and Op Nbr, but how do I get the values to repeat? Thanks so much, Paul

I have several workbooks that contain several worksheets. They were created sequentially by workbook/worksheet with headings only in the first workbook. The data is grouped by an Operation Number "OP NBR". I need to import this data into an Access database and have the OP NBR have it's own...

I have a similar question in regards to the first entry on this thread. My data is all in one query already and I have repeating part numbers and amounts but need to select the most recent reporting date from the result set of the query: PARTS_Query ----- P/N RPT_DT AMT SELECT PJM.PN...

ttt

Actually, I can join the two data sets in Access, but I don't get all of the results from Sheet2 back, only the ones that match the ID tag. I need to return all results from Sheet2 and set the dollar value to Null if there is no match. So I guess I need to know how to do it in both Access and...

I have two spreadsheets. Each sheet shares a common field that serves as an ID tag (mixed text and numbers). Sheet1 has just this ID and a dollar value associated to it. Sheet2 has many more fields but less total records compared to Sheet1. I need to take the dollar amount in Sheet1 and...

I actually need something that can seach the entire server using a where clause. Someone found this script for me: Create table #DB_Name (dbname varchar (100)) Create table #results (dbname varchar (100), tabName varchar (100), colName varchar (100)) Insert into #DB_Name(dbname) select...