I have a splitform where I want to have the button to allow the user to choose and import the file into the table. I have something like this:
Code:
Private Sub Command287_Click() With Application.FileDialog(msoFileDialogOpen) .Filters.Clear .Filters.Add "Excel Files", "*.xlsx,*.xls" .Filters.Add "Access Databases", "*.accdb" .FilterIndex