Search results for query: *

Excel & Access 2003 I have set up a simple macro to import data from a spreadsheet, appending it to an existing table in my database. The macro uses action "TransferSpreadsheet" with arguments Transfer Type: Import Spreadsheet Type: Microsoft Excel 8-10 Table Name: CONTACT File Name: H:\RR.xls...

thanks CMP, was just writing it quick, will add the count rows method, as I will be dowloading these files daily.

Thanks Skip, I will have to do it a few times so I have decided to do it using VBA (I know this was not in the original query) Function Unmerge() Dim i As Integer Dim Legal_Entity As String Dim Portfolio_Owner As String i = 4 For i = 4 To 1441 If Cells(i, 3) <> "" Then Legal_Entity =...

Skivought, I think the IF solution will only display the unmerged values with blanks? I think by propogate the cells, you mean select the bottom right hand corner of the cell to fill in the name for the unmerged cells below. my problem is I have thousands of rows and merged cells. Propogating...

Using Excel 2003 I have a table with merged cells showing the owner of items. I would like to unmerge the cells to show the owner on each row next to the item with no merged cells. Is there any way of unmerging merged cells and adding owner name to each of the unmerged cells. I have to do this...

sorry I did not find an answer

Visio 2003, Excel 2003 I know how to Create an Org Chart using Excel Data, however I would like to maintain this link, so that I can update the excel spreadsheet and then refresh the Org Chart. I cant seem to find this option with out re-creating the chart, by importing the data, this means I...

ok it is now sorted, the problem was the sql, I had removed single quotes from the date char form field, when I did not know the database path connection was wrongs, thanks for your help though

sleipnir sorry, up to now their has been an error in my connection to the database, the path was wrong in my index. I can now see the error when inserting, it says. insert into TRAVEL_REQUEST values(request_id_sequence.nextval,2115704,'London', 'New York' ...

the code still falls at this stage, and the error happens at the execute stage however no error is displayed from OCI Error(), so I am not sure what to do? Any Ideas

I am having problems adding records to my database, the insert statement seems to work ok, but I have an error when the execute command is reached. does anyone know where my problem is? <?php //try first to connect to the database. if we can't then end $dbh =...

thankyou, I realise I should have been adding these error checks, when I add them I find the error appears after the execute statement, does that mean it cannot add this record to the database? if so why? <code> <?php //try first to connect to the database. if we can't then end $dbh =...

I have tried this but nothing is printed from print_r(),it seems the while loop is not entered, and even simple text within the while loop does not appear on screen. I think my problem is in my insert code or fetch code?

...OCIlogoff($dbh); ?> <?php $dbh = db_connect($database_user,$database_password,$database_name); $display = OCIparse($dbh, &quot;select * from TRAVEL_REQUEST&quot;); OCIexecute($display); while(OCIFetchInto($display, $values)) { $current_id=$values[1]; $current_dbdirid=$values[2]...

...,$depart_date, '$purpose', '$justification', '$approval_status')&quot;); ociexecute($stmt,OCI_DEFAULT); $display = ociparse($dbh, &quot;select * from TRAVEL_REQUEST&quot;); ociexecute($display,OCI_DEFAULT); while(ocifetch($display)) { echo ociresult($display).&quot;<br>\n&quot;; }...

...the &quot;[PROJECT_NAME]&quot; is not recognised Set rst = dbs.OpenRecordset(&quot;tblPROJECTS&quot;) NumRecords = DCount(&quot;*&quot;, &quot;tblPROJECTS&quot;) rst.MoveFirst While Not rst.EOF If ![PROJECT_NAME] =...

great thanks

I am trying to update a text file depending on a value entered in a form, the text file's format is Name ID Approval Derek Smith 1 Pending Gopi Chan 2 Approved The values retrieved from the form will be either Accepted or Rejected for the Approval field and the id eg 1. I...

I dont know, I am quite new to php. This does work but I have been advised it sends a file to the server from another post, which said; &quot;include includes a file on the server. You shouldn't specify the full URL to it.&quot;

sorry this is the code, it kept adding a semi colon, but I have added code tags <code> <?php include (&quot;http://es.cib.db.com/organisation/policies/includes/topnav.shtml&quot;); ?> </code>