Question with Formatting name in table

[beatleman]

Hello, i have a excel spreadsheet that has a column with a persons surname (comma) and firstname i.e Steve, Jones.

I export this spreasheet in Access, but would like to splitt the surname and first into separate columns in the table.. whats the easiest way to do this?? Thanks

 

[RexesOperator]

Why not do it in excel first then export access?

 

[ajetrumpet]

What you want to do is called a "parse". Here are some links that might help.

http://support.microsoft.com/?kbid=210588
http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm