Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dpais
Yak Posting Veteran
60 Posts |
 Posted - 2010-03-11 : 09:44:56
|
| hi hopefully i have the right forum - I have a 2000 and 2005 databse - i need to be able to query a xml file.the method i have used is1. open the xml file in excel and then choose to convert it to a table while opening it.2. Save the opened file in .xls (excel) format3. then query the .xls file thorugh openrowset in TSQLthis works fine but it is a manual process - is there a way i can query XML files directly from TSQL in order to automate the process ??thanks for your help. |
|
|
|
|
|
xml to sql - automated ?