This will give all the tables of the database from SQL Server to Access File (.mdb)
1. First create the empty access file .mdb as shown here
2. Right click on the database you want to export
3. Go to TASK
4. Go to EXPORT and Click it, (Import/Export) wizard will appear.
5. Click Next
6. select the source as SQL server client
7. Browse the Access file (.mdb) for the destination file
8. See if the data maping is correct in Mapping
9. (optional) click on preview to see the table to created
10. Chose execute immediately and finish it
11. Once the copying is done, you now have all the tables of your database in the access database file.
1. First create the empty access file .mdb as shown here
2. Right click on the database you want to export
3. Go to TASK
4. Go to EXPORT and Click it, (Import/Export) wizard will appear.
5. Click Next
6. select the source as SQL server client
7. Browse the Access file (.mdb) for the destination file
8. See if the data maping is correct in Mapping
9. (optional) click on preview to see the table to created
10. Chose execute immediately and finish it
11. Once the copying is done, you now have all the tables of your database in the access database file.
No comments:
Post a Comment