Help with Dev Ashish's "Explorer97" database

[Randy]

Access 2000. I downloaded Dev Ashish's "Explorer97" from the MVP website.
This example of finding a file from a drive or folders and then open the
file is almost what I need in my application. What I need instead of
opening a file, is to have the file (excel) selected and then imported into
my table "IDRa". I have struggled with this solution for weeks with no
success. Can anyone help solve this for me. Thank you. Randy

 

[Arvin Meyer [MVP]]

Use the code at:

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

to find the path of the file you need. Then use the TransferSpreadsheet
method (described in the helpfiles) to import the data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Randy]

I have been referred to this code a dozen times, I cant make heads or tails
out of it. I want to use Dev Ashish's sample database "Explorer97" but use
transfer spreadsheet import instead of merely opening a file. Thanks...

 

[Douglas J. Steele]

No offense, but it's not necessary that you understand the code in
http://www.mvps.org/access/api/api0001.htm in order to use it.

Copy everything between Code Start and Code End into a new module. Make sure
you don't use the name of any of the routines in the module as the name of
the module when you save it: use something like mdlFileDialog to be safe.

At the top of the page are 4 lines of code. Those 4 lines of code are all
you need to include in your application (once you've got that module pasted
in) in order to prompt the user to select an Excel file name.

strInputFileName will contain the full path to the file once the user has
selected it: plug that variable name into your TransferSpreadsheet
statement, and you're done.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Randy]

I'm definately not offended, my problem is I am not a pro at access, very
basis. I have been working on this problem for about 6 months. I'v
received your suggestions many times. but I dont know what to do once Iv'e
pasted the module. Dev Ashish "Explorer97" is almost there , why reinvent
the wheel. I need the code to transfer spreadsheet import based on the
sample explorer database. Thanks...Randy