Current recordset d does not support updating locktype dts
I forget the name for now, but if you dig through the SQL administration tool you should see it. Unfortunately I haven't done much SQL work recently.I set it up so well all those years ago I hardly ever have to touch it : D (That's my excuse and it sounds much better that way) teddarr, it looks like you are giving a C# solution...which would be fine if this were ASP.I am getting the following errors when I run the script. Recordset (0x800A0CB3) Current Recordset does not support updating.This may be a limitation of the provider, or of the selected locktype.I wrote a program like that a few years ago and it has helped me to learn many fundamentals that I use on a daily basis now.It has evolved as my skill and experience has evolved. I think you can do this using SQL Server Management Studio in SQL Server 2005, I don't know about 2000.The file Exam Results consists of sheet 1 with the following header info: Index No Surname Name Standard Subject Marks I have created a database name 'Results' in SQL Server 2000 and wish to import that file therein. I think you can do this using SQL Server Management Studio in SQL Server 2005, I don't know about 2000.For 2005, right click on the target database, hover over Tasks, then select import data... You could also write a custom program centered around the excel com object.
I have gone through the document you suggested for inserting data in a database.But as the error suggested, you might just be prevented by provider settings, in which case you will need to contact them.