Quote:
Originally Posted by priyan  Hi,
Can we able to import data from Excel / Text (Tab Delimited) file into SQL server ?
What are all the file types SQL server supports for import data ? |
yes.. we can able to import data from excel or text file...
Import from EXCEL file:
Follow the steps
1. Right click the database--> Tasks--> Import Data
2. Select the Datasource from the drop down and click next
For excel, select Microsoft excel
For text and csv files, select Flat File source
3. Select destination database and table to insert the data from the file to db
Supported file types:
1. xls
2. csv
3. txt
4. mdb
The above files i have tested..