Importing a sharepoint list to an access database gives you a range of flexible convenient options first a copy is made into the access database after which you can specify the lists which you would like to copy. Also you have an option to copy an entire list or only a specific file. Also import operation creates a table in access which copies the entire fields and records specified into the Access.