In my old Access database Table has a column named "Full Name". I want to transfer all the data from that column to my new SQL Server database table (I can use DTS for this part) and I want to split that column ie "Full Name" into "FirstName" and "LastName".
How can I do it.