InfoPath Dev

Hello, I am a newbie at this and it is difficult to find out info on the web for exporting data in my situation.

I have an Infopath form that users enter data outside of the office and they save the form as as an XML file. Later when they come back in the office, they will need to get this data (1 main table, 10 child tables) imported into the SQL Server 2000 database. We cannot use web services because we do not have an Intranet server set up for that yet (we will in the future). So my question is what is the best way to get this data imported? By the way, the InfoPath form is based on a XSD that I created in Visual Studio from the same SQL database. My thought was to use Biztalk to map it. I can drop the XML file into the pickup folder for Biztalk and Biztalk can process it. Can I do this with the Biztalk maps if the data is based on more than 1 table (foreign keys)? Is this the easiest and most reliable way to do this?

Thanks 

Not sure, but sounds feasible.

 Let us know if it works or what you find out.

OK. Also, I am not sure if Biztalk is needed for this scenario. I did see some Microsoft papers that said Biztalk and Infopath work great together; I just don't know about this situation. Are there any easier/better ways to get the infopath data imported in the SQL 2000 database?

thanks

The way I think is the best is via webservices.  You can swnd the data there directly with out the complication of dealing with XML files and Biztalk.

Qdabra provides a suite of premade web services which gives you the ability to extract your form data to a SQL database as well as dynamically query it and an Active Directory web service.

Check it out or email them for a demo.