G
Guest
I found that in Access 2007, at the end of an Import or Export process, it is
possible to save the steps with a 'Name' and I have saved several different
Import operations with different 'Names'.
Within the code I am writing, I would like to use the acCmdSavedImports
command and select the import operation I need by specifying the 'Name' of
the import steps I previously saved. My intention is to avoid opening the
"Managed Data Task" window (where all the Import Names are listed) so that
the user cannot by mistake choose the wrong import 'Name'.
From what I can determine however the:
'DoCmd.RunCommand acCmdSavedImports'
does not seem to accept parametes like the 'Name' of the saved imports. If I
try to force a syntax like
'DoCmd.RunCommand acCmdSavedImports, "my saved import" or variation
thereof I get an error message.
Can somebody please suggest the correct syntax (if available) or suggest a
workaround?
In previous Access versions, it was possible to save import or export steps
for some type of files and then use that name as a parameter in
"TransferText" or similar command.
The help of this expert community is very much appreciated.
possible to save the steps with a 'Name' and I have saved several different
Import operations with different 'Names'.
Within the code I am writing, I would like to use the acCmdSavedImports
command and select the import operation I need by specifying the 'Name' of
the import steps I previously saved. My intention is to avoid opening the
"Managed Data Task" window (where all the Import Names are listed) so that
the user cannot by mistake choose the wrong import 'Name'.
From what I can determine however the:
'DoCmd.RunCommand acCmdSavedImports'
does not seem to accept parametes like the 'Name' of the saved imports. If I
try to force a syntax like
'DoCmd.RunCommand acCmdSavedImports, "my saved import" or variation
thereof I get an error message.
Can somebody please suggest the correct syntax (if available) or suggest a
workaround?
In previous Access versions, it was possible to save import or export steps
for some type of files and then use that name as a parameter in
"TransferText" or similar command.
The help of this expert community is very much appreciated.