Create a LINKed table sourced from the .csv file. Then just do an INSERT INTO [targettable] ([fields]) SELECT [fields] FROM [sourcetable]
e.g.
INSERT INTO MyTarget (field1, field2, field3)
SELECT field1, field2, field3
FROM MySourceCSV
(Assuming you mean a programmatic solution; otherwise just copy'n'paste the data...)