C#

If GUICtrlRead($idCb_Edit_Chosen_Lot) = $GUI_CHECKED Then
		
		
		; We updates the database, with the data from the array
		_SQLite_Exec(-1, "UPDATE tbl_data SET date='" & $sDateTime & "', lot='" & $aData[1] & "', packing='" & $aData[2] & _
				"', sort_number='" & $aData[3] & "', sort_name=" & _SQLite_FastEscape($aData[4]) & ", type='" & $aData[5] & "', grower='" & $aData[6] & _
				"', customer=" & _SQLite_FastEscape($aData[7]) & ", comment=" & _SQLite_FastEscape($aData[8]) & " WHERE date='" & $g_SDateTime & "';")
		; Then we update the Listview
		; In the list view we don't have seperate filds for sort number and name, so we need to combine thoes
		$aData[3] &= ' ' & $aData[4] ; Combine sort number and name in to $aData[3]
		_ArrayDelete($aData, 4) ; then we removes (deletes) the 4'th index from the array $aData
		; Now we creates a loop to update the listview with the data from the array we just changed
		For $i = 0 To 7 Step 1 ; Sins we deletede on index from the array, we only run from 0 to 7
			; Insert the data into listview
			_GUICtrlListView_SetItemText($idListView_Overview, $g_iIndex, $aData[$i], $i)
			
		Next
		GUICtrlSetData($idLbl_LotNr, StringFormat("%06d", $g_iLot - 1)) ; Set the last used lot -1 (we add + 1 later in the script)
		$g_iLot = Null ; Clear the global lot value
		GUICtrlSetState($idCb_Edit_Chosen_Lot, $GUI_UNCHECKED) ; Unchecks the Checkbox
		
	Else ; If it's not a lot edit then
		; We Adds the data to the database
		_SQLite_Exec(-1, "INSERT INTO tbl_data VALUES ('" & $aData[0] & "', '" & $aData[1] & "', '" & $aData[2] & _
				"', '" & $aData[3] & "', " & _SQLite_FastEscape($aData[4]) & ", '" & $aData[5] & "', '" & $aData[6] & _
				"', " & _SQLite_FastEscape($aData[7]) & ", " & _SQLite_FastEscape($aData[8]) & ");")
		
		; Creating an array we can use to adde the data to the listview
		Local $aListViewAdd[1][8]
		; Combine the Sort number and name
		$aData[3] &= ' ' & $aData[4]
		; Update the array, by remove/delete the 4'th index (sortname)
		_ArrayDelete($aData, 4)
		
		; Creating a loop to add data to the array
		For $i = 0 To 7 ; We only run from 0 to 7 course we did delete one index in the array
			$aListViewAdd[0][$i] = $aData[$i] ; Add the data to the new array

		Next
		; Add the data to the listview using the new array, we just created
		_GUICtrlListView_AddArray($idListView_Overview, $aListViewAdd)
		
		; If the user have choosen to reuse the previus lotnumber

		If $g_bReuse = True Then
			$g_bReuse = False
			GUICtrlSetState($idCb_Reuse_Pre_Lot, $GUI_UNCHECKED)

		EndIf
	EndIf

If GUICtrlRead($idCb_Edit_Chosen_Lot) = 1 Then
_SQLite_Exec(-1, "UPDATE tbl_data SET date='" & $sDateTime & "', lot='" & $aData[1] & "', packing='" & $aData[2] & "', sort_number='" & $aData[3] & "', sort_name=" & _SQLite_FastEscape($aData[4]) & ", type='" & $aData[5] & "', grower='" & $aData[6] & "', customer=" & _SQLite_FastEscape($aData[7]) & ", comment=" & _SQLite_FastEscape($aData[8]) & " WHERE date='" & $g_SDateTime & "';")
$aData[3] &= ' ' & $aData[4]
_ArrayDelete($aData, 4)
For $i = 0 To 7 Step 1
_GUICtrlListView_SetItemText($idListView_Overview, $g_iIndex, $aData[$i], $i)
Next
GUICtrlSetData($idLbl_LotNr, StringFormat("%06d", $g_iLot - 1))
$g_iLot = Null
GUICtrlSetState($idCb_Edit_Chosen_Lot, 4)
Else
_SQLite_Exec(-1, "INSERT INTO tbl_data VALUES ('" & $aData[0] & "', '" & $aData[1] & "', '" & $aData[2] & "', '" & $aData[3] & "', " & _SQLite_FastEscape($aData[4]) & ", '" & $aData[5] & "', '" & $aData[6] & "', " & _SQLite_FastEscape($aData[7]) & ", " & _SQLite_FastEscape($aData[8]) & ");")
Local $aListViewAdd[1][8]
$aData[3] &= ' ' & $aData[4]
_ArrayDelete($aData, 4)
For $i = 0 To 7
$aListViewAdd[0][$i] = $aData[$i]
Next
_GUICtrlListView_AddArray($idListView_Overview, $aListViewAdd)
If $g_bReuse = True Then
$g_bReuse = False
GUICtrlSetState($idCb_Reuse_Pre_Lot, 4)
EndIf

'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

private void ConnectToAccess(string accessDB)
{
    try
    {
        connString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={accessDB};Persist Security Info = False;";
        acccessConn = new OleDbConnection(connString);
        acccessConn.Open();
    }
    catch (Exception e)
    {
        MessageBox.Show(e.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation);
    }
}

private static DataSet ToDataSet(string excelFile, int startRecord = 0, int maxRecord = -1, string condition = "")
{
    DataSet result = new DataSet();

    string connString = connString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={excelFile};Extended Properties=Excel 12.0;HDR=No;IMEX=1";
    using (OleDbConnection connection = new OleDbConnection(connString))
    {
        try
        {
            connection.Open();  //==== THROWS HERE

            DataTable schema = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            foreach (DataRow drSheet in schema.Rows)
            {
                if (drSheet["TABLE_NAME"].ToString().Contains("$"))
                {
                    string s = drSheet["TABLE_NAME"].ToString();

                    if (s.StartsWith("'")) 
                    {
                        s = s.Substring(1, s.Length - 2);
                    }
                    var command =  new OleDbDataAdapter(string.Join("", "SELECT * FROM [", s, "] ", condition), connection);

                    DataTable dt = new DataTable();

                    if (maxRecord > -1 && startRecord > -1)
                    {
                        command.Fill(startRecord, maxRecord, dt);
                    }
                    else
                    {
                        command.Fill(dt);
                    }

                    result.Tables.Add(dt);
                }
            }

            return result;
        }
        catch (Exception ex)
        {
            throw;
        }
        finally
        {
            connection.Close();
        }
    }
}