Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addnew
I am uploading data from Excel to Oracle, in which Oracle has a primary key.
I am using a filesearch to get all the files from a folder and upload them to Oracle, but I need to check the primary key to prevent errors. Already tried rs.Addnew, the rest of my code, then On error goto to to skip the rs.Update, but on the next file/iteration of my loop I get an error at rs.Addnew due to it already being called. Is there a way to "close" rs.Addnew, such as rs.Delete, or to check if it is "open" (there is a blank row waiting to be filled) and skip over recalling rs.Addnew? Thank you. Brent |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addnew
how about putting the AddNew portion in a Function to be called each time
around? (Sample from VBA Help.) Function AddName(rstTemp As Recordset, _ strFirst As String, strLast As String) ' Adds a new record to a Recordset using the data passed ' by the calling procedure. The new record is then made ' the current record. With rstTemp .AddNew !FirstName = strFirst !LastName = strLast .Update .Bookmark = .LastModified End With End Function -- Best wishes, Jim "Brent" wrote: I am uploading data from Excel to Oracle, in which Oracle has a primary key. I am using a filesearch to get all the files from a folder and upload them to Oracle, but I need to check the primary key to prevent errors. Already tried rs.Addnew, the rest of my code, then On error goto to to skip the rs.Update, but on the next file/iteration of my loop I get an error at rs.Addnew due to it already being called. Is there a way to "close" rs.Addnew, such as rs.Delete, or to check if it is "open" (there is a blank row waiting to be filled) and skip over recalling rs.Addnew? Thank you. Brent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks | Excel Programming |