hi all,
I am again strucked in my project, i have an excel sheet in following format.

Destination |Codes
Pakistan |92,9242,9251,9221
Pakistan-Mobile |92300,92321,92345

I want to import this file in MSSQL but out put table should be as follow.

Destination |Codes
Pakistan |92
Pakistan |9242
Pakistan |9251
Pakistan |9221
Pakistan-Mobile |92300
Pakistan-Mobile |92321
Pakistan-Mobile |92345

i have script for Excel to DB import, i just need the excel handling in VB to split "Codes" as shown above.

please help me.

Umar