Question: how to export data from sql server to mdb file?
Answer: Hi Open sql Server Management Studio and follow the following steps - Right Click on Database GoTo Task -> Export Data - In the choose a source scree - Select source database and provide the credentials - Press Next - In the choose a destination screen - Select Destination as Microsoft Access - Provide a file Path.