Prompt for spreadsheet to import

[Guest]

I would like to have a spreadsheet that the user is prompted to find and have
that spreadsheet populate to a specific table. I have researched this site a
bit and found that I probably want to use "docmd.transferspreadsheet". My
problem is I can't get the command to work. The following is the command I
am using:

DoCmd.TransferSpreadsheet acImport, , "Test"

I assumed that by leaving areas blank it would prompt the user (like
exporting to excel).

As always thanks for your help.

Robert

 

[Guest]

Have a look at this link
http://www.thescripts.com/forum/thread626872.html

 

[Larry Daugherty]

The prompt is a different kettle of fish altogether. You have to
decide and implement the means for determining the pathname of the
target file.

*Then* you can DoCmd....." to transfer the spreadsheet.

The "navigate to file" dialogue is included in the newest version of
Access. For earlier versions there is code on www.mvps.org/access
that was contributed by Ken Getz. The code looks intimidating but you
can copy and paste and then tweak to completion. It's much handier
for your users than having to find the file and then copy or type it
into a prompt.

HTH
--
-Larry-
--

I would like to have a spreadsheet that the user is prompted to find and have
that spreadsheet populate to a specific table. I have researched this site a
bit and found that I probably want to use

"docmd.transferspreadsheet". My