Export all data from MS Access to any data source, here I have used Excel as target This application helps you migrate any legacy Microsoft Access database to Excel or any other database
Requirements:
- Source Database (Sample included)
- Target Path (For genrated excel files to be copied to)
- OleDb Provider (Connect to Microsoft Access)
The code is in C# and has 2 step process //1. Get all data from the Source database DataSet ds = GetAllDataFromSource();
//2. Export all data to Excel ExportDataSetToExcel(ds);
Feel free to extend this tool to include other database.