Current recordset d does not support updating locktype dts

31-Aug-2015 03:27

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. Moderators This is the only large amount of code I will post.

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. Directory class to look in that folder and find the file name of the excel file you want to enter. OK, the first step in converting the excel file to an Array List is to convert the excel file to a comma delimited string. I'm gonna let this person write the program themselves. Excel; Next, in that first method, create a string variable. make tempfile equal to the method call to the method I just gave you with the filename of your excel file as the argument.

I am getting the following errors when I run the script. Recordset (0x800A0CB3) Current Recordset does not support updating.

current recordset d does not support updating locktype dts-54current recordset d does not support updating locktype dts-45current recordset d does not support updating locktype dts-78

Jared btw, w3schools has a different approach for adding the locktype and cursortype, as well as a pretty good listing of other properties.What you need to do is insert each row to the database as you go through the loop insead of printing the content of the excel sheet to the browser, Have a look at the turorial and see what you come up with. Dr B Hello Dr B Thank you so much for your valuable suggestions.I have gone through the document you suggested for inserting data in a database.Could you please locate the errors and give me your advice.Here are the codes: As the error message suggests, you are not being allowed to make changes to the db.

Jared btw, w3schools has a different approach for adding the locktype and cursortype, as well as a pretty good listing of other properties.

What you need to do is insert each row to the database as you go through the loop insead of printing the content of the excel sheet to the browser, Have a look at the turorial and see what you come up with. Dr B Hello Dr B Thank you so much for your valuable suggestions.

I have gone through the document you suggested for inserting data in a database.

Could you please locate the errors and give me your advice.

Here are the codes: As the error message suggests, you are not being allowed to make changes to the db.

I do not know how to write the data to a table in SQL Server. In reality this project works best as a console app or Win Form app. It is very handy for my sideline gig where I need to process a ton of excel spreadsheets.