Parse Excel data 1

[krets]

How would I go about writing a query that would parse a Name field in Excel formatted as:

Lastname, Firstname

And return the data so it was separated into two columns called LastName and FirstName?

 

[PHV]

A starting point (SQL code):
SELECT xlCol, Left(xlCol,InStr(xlCol,',')-1) AS Lastname, Trim(Mid(xlCol,InStrRev(xlCol,',')+1)) AS Firstname
FROM yourTable
WHERE xlCol Like '*,*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886