Query to import table from access database to sql database

If you are a Non-It people than you can use Export-Import wizard tool.

I need to export the data through sql query. Direct exporting using ssis are difficult for non it peoples

Try with below links:

https://msdn.microsoft.com/en-us/library/ms140052.aspx

https://www.mssqltips.com/sqlservertip/2484/import-data-from-microsoft-access-to-sql-server/

https://www.mssqltips.com/sqlservertip/2656/simple-step-by-step-process-to-import-ms-access-data-into-sql-server-using-ssis/