Convert MDB => SQL Server => CSV using SQL Server 2014 Import and Expo...

Convert MDB to CSV using SQL Server 2014 Import and Export Data 

Software Requirement

  1.  Server 2014 Management Studio
  2.   Server 2014 Import and Export Data

Its take few steps to convert MDB to CSV, No External Tools or Software Require

Steps to MDB to SQL Server

  1. Open Server 2014 Import and Export Data
  2. Click Next
  3.  Select data source as Microsoft Access Database Engine
  4. Select File Using Browse
  5. Click Next
  6. Select Destination as Microsoft OLE DB Provider for SQL Server
  7. Select Server Name
  8. Click New Button for creating New or temp Database
  9. Press Next
  10. Select First Radio button
  11. Press 3 times Next button
  12. And Click Finish

Steps to SQL Server to CSV

  1. Open Server 2014 Import and Export Data
  2. Click Next
  3. Select data source as Microsoft OLE DB Provider for SQL Server
  4. Select Server Name
  5. Select Database
  6. Click Next
  7. Select Destination as Flat File Destination
  8. Select First Radio button
  9. Browse and give any filename and select type as CSV
  10. Click Open
  11. Tick Unicode
  12. Click Next
  13. Select First Radio button
  14. Select Source table
  15. Press Next
  16. Press Finish
Now you can view your CSV file on destination Location

Topics List - Database