Importing only certain fields from a txt file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to routinely import a txt file, but I only want some of the fields.
How can I do this? Do I have to use VBA?
 
For a text file, you can set up an import specification.
in Access Help, type this in:

"Import or link data and objects"

about bullets down you will see "Help > External Data"
it will be grey
click on that and it will tell you what you want
 
You can create an import specification for the file: in the Text Import
Wizard, click the Advanced button. This lets you specify which fields
you want to import (among other things). After you have saved the
specification you can use it again in the import wizard, in the
TransferText macro action, or you can pass its name name to the
DoCmd.TransferText VBA method.
 
Back
Top