gvamsimba
asked on
importing data from text file
HI, i have a notepad with data like this -
"CUS_ORD","ID","C_NAME","C _ADR_1","C _ADR_2","C _ADDR_I1", "C_ADDR_I2 ","C_ADDR_ I3","White Comapny V"
"CAB",4,"Mrs Louisa Henriques","Chaleshurst"," Petworth Road","Chiddingfold","Nr Godalming","GU8 4ST","X"
"BAC",6,"Mrs Pop Frisby","Rosalie Farm","Cowlinge","Newmarke t","Suffol k","CB8 9HU","X"
"BAB",7,"Mrs Sophie Horton","18 Vine Court Road","Sevenoaks",,"Kent", "TN13 3UY","X"
"BAC",12,"Mrs K Kinsky","42 Boscombe Road","London",,,"W12 9HU","X"
when i try to import the data into SQL Server 2005 using import and export wizard, i have used flat file source and loaded the data
into the database.. but my data in the table appears as it is in the source file as below -
"custid" "ID" "custname"
"BAC" 10595 "Mrs Gilly Cowley"
"GAB" 10596 "Mrs Sara Beare"
"GAB" 10597 "Mrs Gina Cernuschi"
can anybody tell me how do i get rid of " " both in Column and rows ?
Many thanks
"CUS_ORD","ID","C_NAME","C
"CAB",4,"Mrs Louisa Henriques","Chaleshurst","
"BAC",6,"Mrs Pop Frisby","Rosalie Farm","Cowlinge","Newmarke
"BAB",7,"Mrs Sophie Horton","18 Vine Court Road","Sevenoaks",,"Kent",
"BAC",12,"Mrs K Kinsky","42 Boscombe Road","London",,,"W12 9HU","X"
when i try to import the data into SQL Server 2005 using import and export wizard, i have used flat file source and loaded the data
into the database.. but my data in the table appears as it is in the source file as below -
"custid" "ID" "custname"
"BAC" 10595 "Mrs Gilly Cowley"
"GAB" 10596 "Mrs Sara Beare"
"GAB" 10597 "Mrs Gina Cernuschi"
can anybody tell me how do i get rid of " " both in Column and rows ?
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regards,
Pedro
www.pedrocgd.blogspot.com