>I have a tab delimited file from a spreadsheet that
>has a field "Name" (includes first and last name).
>
>I am importing the file into a table that has
>"firstName" and "lastName" as seperate fields.
>
>Is there a way to split the field from the text file
>"Name" into two different fields in the
That would be a tough one - you'd first have to make sure every single record has no
more than two "words" in that field. there's no guarantee that a field "name" would
actually always contain only two names, or even two names at all. When I get stuffy, I
spell my name as "A. Marjolein Katsma"
I have a tab delimited file from a spreadsheet that
has a field "Name" (includes first and last name).
I am importing the file into a table that has
"firstName" and "lastName" as seperate fields.
Is there a way to split the field from the text file
"Name" into two different fields in the databas