View Single Post
  #3 (permalink)  
Old October 13th, 2008, 09:28 PM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Since you are using VB, it's easy to do the escaping DParsons noted:
Code:
... = "insert into rjadevlib.f5514ar (f1, f2, f3) " _
    & " values('" Replace(myRow.Item(63),"'","''") & "'," _
    & "'" & Replace(myRow.Item(64),"'","''") & "'," _
    & "'" & Replace(myRow.Item(65),"'","''") & "')"
But can't you come up with better names for your DB fields than f1, f2, and f3????
Reply With Quote