importing data into an access table

Can anyone tell me how to import a csv file with all the correct field names
and data into an existing access table via a macro button or command

Use this command behind your command button.

DoCmd.RunCommand acCmdImport

This will open your browse dialog box to search for your csv file. From there another dialog box will open to allow you to select the delimiters to separate your fields and/or add your field names to either an existing table or create a new table with the imported data.

lwells