How to Import File ?

Step : 1
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