RunCommand acCmdSavedImports 1

[annie52]

How can I specify the saved import specification that I want to run? I don't want my users to have to pick from all the saved imports. I tried:

RunCommand acCmdSavedImports "ImportMilstripOpenHistoryCognos"

but that doesn't work.

 

[traingamer]

See the DoCmd.TransferText Method

expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

e.g.

DoCmd.TransferText(acImportDelim, "ImportMilstripOpenHistoryCognos", etc. etc.)

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[annie52]

Here's what I ended up with:
DoCmd.RunSavedImportExport "ImportMilstripOpenHistoryCognos"

Thanks for the feedback Greg. I haven't used the TransferText or TransferSpreadsheet before so it was good to hear about them!