How to Upload data(.txt/.xlsx/.mdb,etc) to SQL server database?

1. Connect to SQL Server
2. Select the database
3. Right  Click on the Database and select TASK
4. From task select IMPORT 
5. Then an import/export wizard will pop up.
6. Select the type of file you want to upload (flat file source-txt, excel file-.xlsx, access file - .mdb, etc)
7. Select delimited and put the delimiter for text file. else it is not needed.
8. Click next and check the EDIT MAPPINGS, PREVIEW to see how the table will look like and rename the table uder destination.
9. Click Next and then Finish.
10. Hence you data is uploaded to the database

Note: The data should be in proper format and order especially for text data.