| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an Oracle UPDATE Statement from Excel rows
I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a
CONCATENATE Statement, see below. My one problem is getting the "/" into my Oracle statements to separate them so that it will properly process the multiple UPDATE statements. Can someone help me with this formula??? I'm not sure how to carriage retun so that the "/" appears in the first column. This is where Oracle wants it when I copy and paste my values into a SQL Script. Any help is GREATLY appreciated and Thanks in advance for your review and hopeful for a reply. PSULionRP =CONCATENATE("UPDATE TableName SET ColumnName = ", "'", TRIM(E2), "'", " WHERE KeyColumn = ", B2, " /") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating an Oracle UPDATE Statement from Excel rows
use =char(13) to get the CR in.
"PSULionRP" wrote: I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a CONCATENATE Statement, see below. My one problem is getting the "/" into my Oracle statements to separate them so that it will properly process the multiple UPDATE statements. Can someone help me with this formula??? I'm not sure how to carriage retun so that the "/" appears in the first column. This is where Oracle wants it when I copy and paste my values into a SQL Script. Any help is GREATLY appreciated and Thanks in advance for your review and hopeful for a reply. PSULionRP =CONCATENATE("UPDATE TableName SET ColumnName = ", "'", TRIM(E2), "'", " WHERE KeyColumn = ", B2, " /") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Data Entry Form to Update Multiple Excel Records atOnce | Excel Discussion (Misc queries) | |||
| Excel VBA against Oracle | Excel Discussion (Misc queries) | |||
| can a dde link be used to populate excel creating new rows? | Excel Discussion (Misc queries) | |||
| Excel Access and Oracle | Excel Discussion (Misc queries) | |||
| How to update ORACLE query definition in Excel file | Links and Linking in Excel | |||
Linear Mode
