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: In Visual Studio I created a new project I added Connected to Access database using the Database Explorer, this created a link in the App_Data folder Then on the default page I allowed the user to place the file name, I then added a new DataSet, created a new TableAdapter, put the query I needed in there and 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 =...
Just some opinions and things I have committed to virtual prosperity just in case UGAF