Separating "," in Access

[lazerzubb]

I need help, first of all, i can't paste it in to a .txt document and then import it, it screws up when i paste it.

Is there any way to seperate a field in access, example:

Lazerzubb ,Shak

Is in a ROW, and in the same column, now is there any way i can put everything after the "," in to a new column so it doesn't exists in the first field anymore?

Normally i would just import from a .txt field and use "," as a seperator but since i can't do this here, i need help with other solutions.

[WebJoe]

I'm not sure if I understand your Q, but how about something like

UPDATE ... SET [DestTable].[DestCol1] = 
Left([SrcTable].[SrcCol],InStr([SrcTable].[SrcCol],,', ')-1), [DestTable].[DestCol2] = 
Right([SrcTable].[SrcCol],InStr([SrcTable].[SrcCol],', ')-1);

[aspdaddy]

what about pasting it into excel and saving as .csv - then importing.