Posted by Wes Groleau on 11/21/06 04:18

Wes Groleau wrote:
> OK, I do know how to read and write XML. But can an XML file
> be formatted so that the utility will create multiple tables
> with the appropriate foreign keys to relate them?
>
> I got the impression when I was reading about it that one
> XML file makes one table and vice versa.

The impression was wrong. I studied the MS KB article cited
earlier, and I can easily make such XML files. Only, the process
of transforming the file into XML is similar to the process used
by bulk load to turn the XML into records. So I suspect it would
add a little speed if I went directly to records.

--
Wes Groleau

Words of the Wild Wes(t) = http://ideas.lang-learn.us/WWW

• Next in forum: appending two datetimes which were converted from strings
• Prev in forum: Re: Help with a complex UPDATE query
• Thread view: Re: Converting a file into multiple tables

[Reply to this message]