Import Excel to MSAccess with prompt for filename

[datavisions]

I'm trying to use the DoCmd.Transferspreadsheet to IMPORT an Excel spreadsheet into an existing table. It works fine if I specifically name the Excel file to be imported, but if I leave off the import filename (like you can do on exports), it won't prompt me for a filename and location, but rather gives me an error message. What are my alternatives/

 

[scking]

Build the requirement for an imput filename into a form that transfers the spreadsheet. Even to using a common dialog to browse for the input file.

Steve King

txtInputFile_AfterUpdate

If Len(Me.txtInputFile)>0 Then
If Len(Dir(Me.txtInputFile))>0 Then
'File has been specified and verified
'so run the transfer spreadsheet code
End If
End If

End Sub Growth follows a healthy professional curiosity