|
Home > Archive > MS SQL XML > October 2005 > excel generated xml file to sql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
excel generated xml file to sql
|
|
| juvethski 2005-10-27, 9:25 am |
| 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!
| |
| Michael Rys [MSFT] 2005-10-27, 9:25 am |
| Do you want to import the XML as a BLOB or put it into tables?
Michael
"juvethski" < juvethski@discussion
s.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A- 224E5E59239D@microso
ft.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!
| |
| juvethski 2005-10-27, 9:25 am |
| 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@discussion
s.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A- 224E5E59239D@microso
ft.com...
>
>
>
| |
| juvethski 2005-10-27, 9:25 am |
| 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@discussion
s.microsoft.com> wrote in message
> news:A2B28AB0-A366-4E5E-AF3A- 224E5E59239D@microso
ft.com...
>
>
>
| |
| Bertan ARI [MSFT] 2005-10-27, 9:25 am |
| 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@discussion
s.microsoft.com> wrote in message
news:A2B28AB0-A366-4E5E-AF3A- 224E5E59239D@microso
ft.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!
|
|
|
|
|