excel generated xml file to sql

hi,
i hv a report generated from a web-based application. although the extension
is '.xls', this is really an xml doc (am i correct?). i say this because if i
'save as' the file, the extension that appears is 'XML spreadsheet'.
i don't want to open the file and save it as an excel file, because that
would mean there will be a manual process in my script. what is the best way
to import this file directly to sql? i tried DTS but DTS cannot recognize the
file.
thanks for your help!
Do you want to import the XML as a BLOB or put it into tables?
Michael
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!
|||i want to put it into a table. thanks in advance for the help.
cheers.
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>
|||i want to put it into a table. the table can be existing, or not yet
existing. thanks in advance.
cheers
"Michael Rys [MSFT]" wrote:

> Do you want to import the XML as a BLOB or put it into tables?
> Michael
> "juvethski" <juvethski@.discussions.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
>
>
|||You may consider use Bulkload from Sqlxml or using OpenXml i nT-SQL if your
file size is not big.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"juvethski" <juvethski@.discussions.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A-224E5E59239D@.microsoft.com...
> hi,
> i hv a report generated from a web-based application. although the
> extension
> is '.xls', this is really an xml doc (am i correct?). i say this because
> if i
> 'save as' the file, the extension that appears is 'XML spreadsheet'.
> i don't want to open the file and save it as an excel file, because that
> would mean there will be a manual process in my script. what is the best
> way
> to import this file directly to sql? i tried DTS but DTS cannot recognize
> the
> file.
> thanks for your help!