move all characters before first comma - help!

[Guest]

Hi,

I have imported a .CSV of 58,000 names and addresses into an Access
table. The names are of the form "Surname, Firstname M" (where M is
middle name initial (if there is one)) all as a single field.

I need this data in two separate fields:
<Surname> <Firstname M>

i.e. split after the first comma, delete the comma and the following
space.

Can anyone offer a suggestion as to how I might achieve this?

Thanks,
Paul.
--

 

[Guest]

Ha! Solved it!

I imported into Excel first - Excel has the option of using both tab
AND comma as a field separator at the same time (I just had to move
the heading titles along one column in the resulting imported
sheet).
Access can then read the Excel file.
--