import xml to mdb
<p>I'm trying to export a SQL-Server query to an XML file now and I want to import that file to Access. I don't understand how to do this.</p>

<p>Here is the code I use to generate the XML: </p>

<pre><code>protected void Button1_Click(object sender, EventArgs e) {
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlSconn"].ConnectionString);
    con.Open();

    string strSQL = "select * from dbo.table_"+test.Text.ToString()+"";
    SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);

    DataSet ds = new DataSet();
    dt.Fill(ds, "" + test.Text.ToString() + "");
    ds.WriteXml(Server.MapPath("temp.xml"));
}
</code></pre>
