[AccessD] Running a saved import from a macro

Doug Steele dbdoug at gmail.com
Thu Jun 21 11:28:28 CDT 2012


Dale:

Here is some sample code to import a text file in VBA:

  'import the text file using the import spec 'Import_Cables'
  'which was built and saved using the text import wizard (file>get
external data> Import...> choose a file> Advanced > Specs...)

  DoCmd.TransferText acImportDelim, "Import_Cables", "tblImport_Cable",
txname

To build a macro line do do this, select 'TransferText' (or possibly one of
the other Transfers if you're not using a text file).  Then fill in the
Transfer Type, Specification Name, the output Table Name and the input File
Name

Hope this helps

Doug

On Thu, Jun 21, 2012 at 7:56 AM, Dale Kalsow <dkalsow at yahoo.com> wrote:

> Good Morning Everyone,
>
> Can some tell me how to run a saved import by using a macro?
>
> Thanks!
>
> Dale
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list