Importing a selected file

[Matthew]

I am writing some code and I want to open a open file
dialog box within access (writing in vb). I want the user
to be able to identify which Excel File he/she wants to
import. How do I create an open file dialog box?

 

[Ken Snell]

See the ACCESS Web:

http://www.mvps.org/access/api/api0001.htm

 

[Matthew]

I tried that code and it has compilation errors. I'm
working with Access 2000 and it says that that piece of
code is for Access 95. Does that have anything to do with
it?

 

[Ken Snell]

This code is successfully used in all versions of ACCESS. Not sure what
compilation errors you got (can you post what they were?), but be sure that
you put ALL the code (there are multiple procedures in the code list) into
your database.