This is code that I used with DAO and Access97. However, when I try and run it with ADO and SQL server I get an error on the RS.AddNew "Object or Provider is not capable of performing this type of operation." I have looked at doing this through Insert statements, Bulk Copy, or DTS but I am perfornming alot of if then statements that seem to be easier with the Line Input function rather than copying to one table then manipulating, then copying to another table, then deleteing temp table etc, etc, etc. I have been working with SQL server for about 2 weeks now and I can't say that I like it. (I hope it gets better).


'************************************************
rs.CursorLocation = adUseClient
rs.Open "Select * From tMaster", cn, adOpenDynamic

Open (App.Path & "\import\paid.txt") For Input As 1
While Not EOF(1)
Line Input #1, sRecord
rs.AddNew

rs!acctNum = "1234567"

rs.Update
Wend
'***************************************************