Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Private Sub cmdImport_Click() If IsNull(Me.txtFileName) Or Len(Me.txtFileName & "") = 0 Then MsgBox "please select the excel file" Me.cmdSelect.SetFocus Exit Sub End If DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Import", Me.txtFileName, True End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
how to predefine file name on Application.FileDialog(mso
|Win 10 Automation Error with .doCmd in Access||2||80|
|Access 2007 Compact and Repair Back-End Database||9||43|
|Best way to get data into a database||12||47|
Join the community of 500,000 technology professionals and ask your questions.