pjmatelli
Board Regular
- Joined
- Oct 13, 2005
- Messages
- 206
Hey All,
I am trying to import an Excel file into an Access table. The problem is that several people will be getting the Excel file from an external source and I don't want to hard code the location of the file or the file name. I'd like to have the code prompt the use with the open dialog box so that the user can go 'get' the file wherever they may have put it. Hope that makes sense...and any help, as always, is greatly appreciated!
TIA
I am trying to import an Excel file into an Access table. The problem is that several people will be getting the Excel file from an external source and I don't want to hard code the location of the file or the file name. I'd like to have the code prompt the use with the open dialog box so that the user can go 'get' the file wherever they may have put it. Hope that makes sense...and any help, as always, is greatly appreciated!
TIA