I'm trying to take one field in a table (LPs), divide it into several fields, and append those fields into another table (Performers). I was hoping this would do it:
INSERT INTO Performers ( Performers.LastName, Performers.FirstName, Performers.BandName, Performers.OriginalName )
SELECT DISTINCT getLastname(LPs.[Musician(s)]) , getFirstname(LPs.[Musician(s)]), getBandname(LPs.[Musician(s)]), LPs.[Musician(s)]
FROM LPs;
My assumption is if I simply go from SQL View to Datasheet View that it will do whatever is written, and thus would insert data into the table, but apparently I'm wrong. The data in Datasheet View shows exactly what I want, four fields containing parts of the original field properly parsed, but nothing gets added to Performers. What do I need to do to populate Performers?
Thanks.