Hey guys,
I'm a complete newbee to this so any help will be greatly appreciated. Here is my problem.
I'm working on a project right now that basically involves two systems. One is a PDA and another is a Computer running SQL server 2000. I'm recording job information on the PDA and saving the collected job information in the form of an XML file. I want to be able to insert this data from the XML file on the PDA into my SQL server database on the computer. I have set up the necessary job tables inside the SQL server. I've been looking at OPENXML to extract the data from the XML file but can't really get my head around it. Can anyone give me some basic instuctions on how i can go about this?
Thank you
I'm a complete newbee to this so any help will be greatly appreciated. Here is my problem.
I'm working on a project right now that basically involves two systems. One is a PDA and another is a Computer running SQL server 2000. I'm recording job information on the PDA and saving the collected job information in the form of an XML file. I want to be able to insert this data from the XML file on the PDA into my SQL server database on the computer. I have set up the necessary job tables inside the SQL server. I've been looking at OPENXML to extract the data from the XML file but can't really get my head around it. Can anyone give me some basic instuctions on how i can go about this?
Thank you