Docmd.RunCommand acCmdImport

  • Thread starter Thread starter glnbnz
  • Start date Start date
G

glnbnz

I have this code

Docmd.RunCommand acCmdImport

I was wondering if I can code the path to the directory so when the 'Import'
box opens it is already at the folder of the file that needs importing?

thanks in advance
glnbnz
 
Not using that kind of code.
Since you don't say what kind of file you are importing, I can't be
specific, but to import Excel files, see VBA Help for the TransferSpreadsheet
method, for text files, see TransferText.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get filename during Import Wizard. 2
RunCommand Canceled error 3
Import Text file via browse box - import specs? 3
default to xls 2
Format Table Column 4
import file 1
delete table 1
SetFocus not working 2

Back
Top