John please elaborate on what you mean by "migrate the bak file to Access".
What exactly are you wanting Access to do with that file?

i am using a local software to store my clients information. It backs up the  data in the format of .bak . I now want to transfer these data to access

According to the picture you provided the information is being stored in a compressed (.zip) format.
You would need to extract those files to a folder then work with the actual files.  

Using append and update queries to bring it into Access.  Access, I don't believe, will not be able to read directly from the .zip.

Hi John and Scott
I have never heard of a .bak file before and did a quick Google.
It appears that you need to use this file through a SQL Sever to restore your database.
Best you do your own research also and make back up copies of your database and not just backups.
Sorry to butt in but that is why I visit this forum as I learn from them as well.

thanks allen
i ve restored the bak file in sql server and can look into the data via SSMS.
do u know how to import it to access

John
The easiest way would be to directly link the table from your SQL Server.  I see you have Access Expert 24.  Check out Lesson 4 - Online SQL Server Database

Once you have a linked table from your server, you can treat it as another regular table.  Then by using Append and Update Queries you can bring the data into your tables.

You didn't really explain what it is that you are doing.  It might not be necessary to import the data into your tables depending on what you are doing.  Access can be the Front End to interact with the SQL Server Tables.

I really can't give you good advice beyond that.  I don't have or use SQL Server but have gone through the courses.
Get into the Index (Microsoft Access Outlines) and do some searching.  Use Ctrl-F and type in your search terms.
Check out the Access SQL Server Online as well.

just bought the course  Access SQL Server Online
will learn from it
thanks guys