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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 import xml to sql?

Author  Topic 

juvethski
Starting Member

46 Posts

Posted - 2005-09-30 : 10:54:19
hi,
is there a way to import xml files directly into sql (existing or not yet existing)?

thanks!

Kristen
Test

22859 Posts

Posted - 2005-09-30 : 11:21:05
You can parse XML directly into tables (using the names of the columns, or a "template") using plain SQL syntax.

Or there is a Bulk XML import tool.

Kristen
Go to Top of Page

juvethski
Starting Member

46 Posts

Posted - 2005-10-01 : 00:23:30
what is the bulk xml tool? is it XML IImport?
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-10-01 : 01:26:13
COM object which is part of SQLXML 3.0

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp?frame=true

Kristen
Go to Top of Page

juvethski
Starting Member

46 Posts

Posted - 2005-10-01 : 14:37:37
quote:
Originally posted by Kristen

COM object which is part of SQLXML 3.0

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp?frame=true

Kristen



thanks for the responses krister.... the docs however doesnt show me how to write it... can you please show me some examples on how this was done? thanks!
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-10-02 : 05:58:59
http://www.google.com/search?q=sqlxml+bulk+import

gives you no ideas?

Kristen
Go to Top of Page

juvethski
Starting Member

46 Posts

Posted - 2005-10-02 : 12:55:59
got it, thanks a bunch. more power to you.
Go to Top of Page

juvethski
Starting Member

46 Posts

Posted - 2005-10-03 : 02:18:16
quote:
Originally posted by Kristen

COM object which is part of SQLXML 3.0

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp?frame=true

Kristen



thanks for the responses krister.... the docs however doesnt show me how to write it... can you please show me some examples on how this was done? thanks!
Go to Top of Page
   

- Advertisement -