copy CSV file to MS Access Table

Question

using C# I am trying to create a console app that reads a CSV file from a specific folder location and import these records into a MS Access Table. Once the records in the file have been imported successfully I will then delete the .csv file. 

So far this is what I have:

public static DataTable CsvFileToDatatable(string path, bool IsFirstRowHeader)//here Path is root of file and IsFirstRowHeader is header is there or not
        {
            string sql = string.Empty;
            DataTable dataTable = null;
            string databaseName = string.Empty;
            string pathOnly = string.Empty;
            string fileName = string.Empty;
 
            try
            {
                databaseName = Path.GetDirectoryName(ConfigurationManager.AppSettings["DatabaseName"]);
                pathOnly = Path.GetDirectoryName(ConfigurationManager.AppSettings["QuantumOutputFilesLocation"]);
                fileName = Path.GetFileName(ConfigurationManager.AppSettings["CSVFilename"]);
 
                sql = @"SELECT * FROM [" + fileName + "]";
 
                using (OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseName + ""))
                {
                    using (OleDbCommand command = new OleDbCommand(sql, connection))
                    {
                        using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
                        {
                            dataTable = new DataTable();
                            dataTable.Locale = CultureInfo.CurrentCulture;
                            adapter.Fill(dataTable);
                            //this is what I'm trying
                            adapter.InsertCommand = new OleDbCommand("INSERT INTO tblQuantum (DateEntered, SerialNumber, ModelNumber, BatchNumber, DeviceType, RatedPower, EnergyStorageCapacity " +
                                                                     "MaxEnergyStorageCapacity, User_IF_FWRevNo, Charge_Controller_FWRevNo, RF_Module_FWRevNo, SSEGroupNumber, TariffSetting) " +
                                                                     "VALUES (?, ?)"); //how do i read each row in the dataTable to retrieve the necessary values for each column??
                            adapter.Update(dataTable);
                        }
                    }
                }
            }
            finally
            {
 
            }
            return dataTable;
        }

Can I just go ahead an save the datatable to a table I have created in the Access DB? How would I go about doing this? Any help would be great