A simple how to export from TableAdapter to XML file

I recently wanted to import data from an existing system that is written in Access. The system allows for XML imports. Since I needed to do some background programming on the system, I opted to rather to it programmatically than use the standard export, since I would have to do it a few times, and also manipulate the data once it was imported and then exported.
I struggled to find information on how to do this, so eventually decided to figure it out myself and this is how I did it:

1. In Visual Studio I created a new project
2. I added Connected to Access database using the Database Explorer, this created a link in the App_Data folder
3. Then on the default page I allowed the user to place the file name,
4. I then added a new DataSet, created a new TableAdapter, put the query I needed in there and
5. Then in my code I exported to XML

So the in Default.aspx It looks like this:

File to Export to:
<asp:TextBox ID="tbxCustomersToXML" runat="server" Width="375px" ToolTip="XML File Target" 
Text="C:\Users\username\Documents\junk\Customers.XML" />
<asp:Button ID="btnCustomersToXML" runat="server" Text="Customers TBL to XML" onclick="btnCustomersToXML_Click" />
<br />
<asp:Label ID ="lblStatus" runat="server" />
<br />

And the in Default.aspx.cs looks like this:


protected void btnCustomersToXML_Click(object sender, 
EventArgs e)
 {
  if (tbxCustomersToXML.Text != "")
     {
     try
       {
         CustomersTblTableAdapter dtaCompanys = new CustomersTblTableAdapter();
         // retrieve the data using GetData since this is where the correct Query is
         TrackerCompaniesDataSet.CustomersTblDataTable dtCompanys = dtaCompanys.GetData();
         System.IO.StreamWriter swXMLTarget = File.CreateText(tbxCustomersToXML.Text);

         dtCompanys.WriteXml(swXMLTarget, XmlWriteMode.WriteSchema);
         lblStatus.Text = "Extract status: Done!";
       }
       catch (Exception ex)
       {
         lblStatus.Text = "Extract status: The file could not be exported. The following error occurred: " + ex.Message;
       }
     }
   }

Hope that this helps someone, I may need to refer to it myself.