Excel file, scrubbing name

#1

In an Excel file I have name in this format (Jones, Shawn)
as one field. How can I export the data into two fields
(firstname, lastname) opposed to one field?

#2

Use a DataPump to pull data from the Excel file and use an ActiveX Script
Transform to split the field. You can use either the Mid or Split VBScript
functions to actually do the splitting.

--
Darren Green
http://www.sqldts.com
"Shawn" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

In an Excel file I have name in this format (Jones, Shawn)
as one field. How can I export the data into two fields
(firstname, lastname) opposed to one field?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Excel file, scrubbing name

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Excel file, scrubbing name - 10-12-2004 , 02:15 PM

Re: Excel file, scrubbing name - 10-13-2004 , 05:48 AM