Set import dialog box

[arage]

Set import dialog box
Is it possible through code to set the LOOK IN, FILE NAME, and FILES OF TYPE options in the import dialog box through code??

 

[PaddyIrishMan]

Hi arage,
I'm not sure what you mean by the set import dialog box but it sounds like this is a common dialog control.
Maybe you can create your own set import dialog by adding a common dialog control from the "include activex control" option.

You can then set the dialog to look in a certain directory for a certain file etc.
If this is what you are looking for I can give you more info on the common dialog if need be.

HTH
Patrick.

 

[George Too]

Hi,
take a look at this posts and see if that's what you are looking for. I implemented it in my database to import an Excel file. It does everything you are asking for. It just works just great.

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=132175#post132175