July 22, 2012 at 9:29 pm
When i try to import data from Flat File to SQL Server with text qualifier as(")
The met data imports with out any issues.But column remains the same
To have more clarification
My Test Data for importing data from Flat File to SQL Server
"FirstName","MiddleName","LastName","ContactID"
"Gustavo","","Achong","1"
"Catherine","R.","Abel","2"
"Kim","","Abercrombie","3"
"Humberto","","Acevedo","4"
"Pilar","","Ackerman","5"
"Frances","B.","Adams","6"
"Margaret","J.","Smith","7"
"Carla","J.","Adams","8"
"Jay","","Adams","9"
"Ronald","L.","Adina","10"
When i import data to SQL Server the text qualifier does the trick by removing the double quotes.But Column header remains the same.
How we can remove this stuff?
"FirstName","MiddleName","LastName","ContactID"
Gustavo,,Achong,1
Catherine,R.,Abel,2
Kim,,Abercrombie,3
Humberto,,Acevedo,4
Pilar,,Ackerman,5
Frances,B.,Adams,6
Margaret,J.,Smith,7
Carla,J.,Adams,8
Jay,,Adams,9
Ronald,L.,Adina,10
July 22, 2012 at 9:42 pm
Go it resolved
Thanks
July 26, 2012 at 10:55 am
Proper forum etiquette would be to share your solution so others can learn and benefit too. If you have a moment would you kindly elaborate on what you did to resolve the issue?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply