want to automate importing files from dbf file

[kevcri]

I want to automate importing of dbf files. the files are in a folder based on name of job. optimally what I would like to do is

user opens program and is prompted for folder location

program opens folder and imports or links selected dbf files.(the files are always named the same thing and have the same colums)

program creates reports

program exports reports to same folder.

program drops tables

I can do most of this stuff, however I can't figure out how to get the user to point to the folder.

currently the user has to import the files manually and export the report manually.

thanks for help

 

[FoFa]

Well, you could use FILESYSTEMOBJECT to give them a list of folders, but I think I would CommonDialog and make them select a file in the folder (which you can strip off).
If you wanted to get fancy, you could FileSystemObject in conjunction with TreeView control and let them select.

 

[ghudson]

Browse [Find a directory or file]