tag:blogger.com,1999:blog-2993076825914312059.post4161442619672774519..comments2023-12-19T02:27:38.291-08:00Comments on Blog for Programmers: Procedure to insert XML Data in Sql Server Database using OPEN XMLUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2993076825914312059.post-31700771777039430842008-12-19T15:21:00.000-08:002008-12-19T15:21:00.000-08:00Go through by blog article Read Excel file from VB...Go through by blog article Read Excel file from VB 6.0. Then after reading it use the data to convert it into xml tags and save it in the text file with the extension .xml. This should work for you.rprateekhttps://www.blogger.com/profile/17124325369293678040noreply@blogger.comtag:blogger.com,1999:blog-2993076825914312059.post-23741092920089982102008-12-18T23:48:00.000-08:002008-12-18T23:48:00.000-08:00HiI just run through your blog its really cool, I ...Hi<BR/>I just run through your blog its really cool, I am new to VB. I developing small application in VB. Retrieving Excel data and i need to convert those data into XML file. Its possible from VB, I am awaiting for your response.<BR/><BR/>Thanks and Regards<BR/>S.Prabuபிரபு Nivashttps://www.blogger.com/profile/13004334023280902014noreply@blogger.comtag:blogger.com,1999:blog-2993076825914312059.post-91184088589755822382008-12-01T16:05:00.000-08:002008-12-01T16:05:00.000-08:00just write create table statement first in the sto...just write create table statement first in the stored procedure, create table and then write the insert into statement. This should work for you.rprateekhttps://www.blogger.com/profile/17124325369293678040noreply@blogger.comtag:blogger.com,1999:blog-2993076825914312059.post-83739345382373248222008-12-01T03:59:00.000-08:002008-12-01T03:59:00.000-08:00hi,Thanks for you article.What should i do if i wa...hi,<BR/>Thanks for you article.What should i do if i want to create table from xml dynamically first and then insert data to that table ?snehahttps://www.blogger.com/profile/12358264710922224022noreply@blogger.com