If file type in (*.txt,*.csv,*.xls,*.mdb)then
Open "Enterprises Manager"
Go to tools Menu -------> Click Import Data
then Click "Next"
Click "Next"
Then select a file type "text file"
Then "select import file name from local or network system"
1. Select the "ROW deliminater"
2. Select the "Text Qualifier" eg:"Single Quote(')"
3. Select "Skip Rows" eg: skip Rows (5) then the first five data will skiped
4. Select "First row has column names" then first row considered column name
then click "Next"
Select Column specifer eg:"Comma","Tab","Semicolan","Other="
Select Desitination "Microsoft OLE DB Provider for SQL Server"
Select Server Name eg:"TEST34"
then give SQL Server Authoration Username & Password
and select Database name
Click -------->"Next"
Click the desitination and give table name which is create
eg:"B&C - Reports.dbo.test"
Then Click transformation
All Columns must select type any one of the below as per the data format
"Binary","Bigint","bit","char","Datetime","Decimal","flot","Image","Int","Money",
"nchar","ntext","numeric","nvarchar","real","smalldatetime","smallint",smallmoney",
"sql_Variant","text","timestamp","tinyint","uniqueidentfier","varbinary","Varchar"
Click -----> Next ---------- > Next then -------- > Finish
The below picture shown as the data import to table
The Below picture shown as the data imported successfully
