Are there any ways of importing txt file into sql server? I've try Bulk insert may be there's another?
you can also try SSIS packages
To expand a bit more on @yosiasz suggestion: Import/Export wizard allows you to use SSIS under the covers without having to go through the process of using Data Tools to build an SSIS package. Right-click on the database name in SSMS object explorer,Tasks -> Import Data. The wizard will walk you through it, and will also give an opportunity to save the task as an SSIS package so you can reuse it later if needed.
Thanks! I'll be taking notes of these.