Search results

So this is the final code. I managed to get this to work in the way I needed. Private Sub cmdSelectExcelFile_Click() Dim dlg As FileDialog Dim FileSelected As String Set dlg = Application.FileDialog(msoFileDialogFilePicker) With dlg .Title = "Select the Excel file to...

I think that I will need to limit the file types to xls and xlsx, that is not a problem though. The next thing I need the code to do is take the selected file and append it to a table in the database, "Table - Referrals Fillable"

Thank you! here is the code I am dealing with for reference. Private Sub cmdSelectExcelFile_Click() Dim dlg As FileDialog Dim FileSelected As String Set dlg = Application.FileDialog(msoFileDialogFilePicker) With dlg .Title = "Select the Excel file to import"...

I will preface this by saying this is my first attempt at access coding ever! I am trying to work this out in Access 2010. I need an automated process so that different users can select tables from different places and it go to the correct table without any worries. I have made the code work for...