Question: how to import data from access to sql server using query?
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.