Question: how to import data to sql server from access?
Answer: Open SQL Server., Right click on the database folder/node to import., Click on All tasks., Click on Import Data., The Data Transfer Services Wizard screen will appear., Click on Next., The Choose a Data Source screen will appear., In the Data Source field, choose Microsoft Access.