Automating Import Export Specifications

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Good Afternoon,

Is there a way to automate a Data Import Function using
the Import/Export Specifications file that I have saved.
I would like to create VBA Code that automates this
process and I would like to avoid the user from having to
manually walk through the Data Import function step by
step. I would think there is some code that could be used
to refer to the import/export specifications. Any help
would be much appreciated.

TIA,

Tony
 
Look up the TransferText Method of the DoCmd object in help. It corresponds to the TransferText Macro Action.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top