Topic: How to import data from file in SQL Server

Hello Everyone,
Is there any option to import data from file in SQL Server, file can be txt, csv, xls etc. Please give me appropriate answer.
Thanks in advance!!

Re: How to import data from file in SQL Server

1. Start SQL Server Management Studio
2. Connect to your database
3. File > Open > File and pick your file
4. Execute it

Re: How to import data from file in SQL Server

downloud