Import dialog form

Import dialog form

Post by Sm9lQTIwMD » Sun, 18 Feb 2007 01:13:13


I need to be able to browse for excel files to import into Access tables from
within my app. Since I have no guarantee the files have a consistent name or
location, I will have to be able to select the file I need. Is there away to
do this using the TransferSpreadsheet method?If not, is there a more elegant
way of handling this?
 
 
 

Import dialog form

Post by Sm9obiBOdX » Sun, 18 Feb 2007 01:52:16

Hi Joe,

There's code here to invoke the standard Windows File Open dialog:
http://www.yqcomputer.com/

--
John Nurick
Microsoft Access MVP