G
Gino
I initially posted the question below under "Access Database Import/Export
Data" section. This section may be a bit hidden down the forum hierarchy and
since I have not received any suggestions yet, I am posting this again under
the "Programming Questions" hoping this to be more visible.
Thank you for the help anyone can provide.
___________________________________________________________
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 programmatically
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, as a "specification" and then use that as a
parameter in "DoCmd.TransferText" or similar command.
The help of this expert community is very much appreciated.
Data" section. This section may be a bit hidden down the forum hierarchy and
since I have not received any suggestions yet, I am posting this again under
the "Programming Questions" hoping this to be more visible.
Thank you for the help anyone can provide.
___________________________________________________________
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 programmatically
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, as a "specification" and then use that as a
parameter in "DoCmd.TransferText" or similar command.
The help of this expert community is very much appreciated.