Thank you.. I see I have made more of a quest then I thought.*L* Here is the SQL line that I am using for this proj.. I have a excel writing codes so i know this should be simple, but I really don't know SQL as greatly as I should.. I apologise I I upgraded my dbgrid when I got vb6.. So I have the standard ver. not much better I know, but it works..

Private Sub cmdSearch_Click()

Data1.RecordSource = "SELECT * FROM Info WHERE ClockNumber = " & txtTargetName.Text & ""
On Error GoTo eh
Data1.Refresh

TDBGridS1.Visible = True

If txtTargetName.Text = "" Then TDBGridS1.Visible = False

eh: Exit Sub
End Sub


I just have to replace the sql line in the Excel exporting code to the sqlin this correct? *Kinda lost, but learning*