Export database from SQL Server to Microsoft Access

This will give all the tables of the database from SQL Server to Access File (.mdb)

How to create .mdb file in Access 2007 or Access 2010?

1. Open the Access file and click on new database

Data truncation Error in Uploading database to Access?

This error can be solved by

1. making all the data type field as text
2. if the problem persists, see the error column in which truncation occur and set the datatype as MEMO