Hello, I am new to the SQL environment and need to use bulk import to insert about 600-700 new xml files a day into SQL Server 2000. My VB .NET code is working fine to handle this, I just need some help with the schema work. If someone could provide an example of how to update multiple unrelated tables in a single database, I would be very appreciative. I can do a single table with no problem, its just when I try to reference a second table that I have problems.

Sample XML Document:

<?xml version="1.0" ?>
<root>
<Customer>
<FName>Tom</FName>
<LName>Jones</LName>
<Order ID="1">
<Account>123456</Account>
</Order>
<Address>123 Main St.</Address>
</Customer>
<root>

SQL Tables:
1. Customers
2. Orders

This is just a basic, but I need something to go off of to set up a SQL Table relation from the Elements/Attributes to map them to the right table columns. My actual file is dynamically generated and may have upto 11 or 12 tables, or as few as 2 or 3. Any help or further explination would be most helpful.

Sincerly,
William