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" ?>
<Order ID="1">
<Address>123 Main St.</Address>

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.