Importing only certain fields from a txt file

T

ts

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?
 
K

Klatuu

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
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add file name to table when importing several txt files using an- 2
Making a macro only work on certain files 2
Some mail merge fields not pulling into document 2
Filtered view of Visio Chart 0
Import all files in directory 1
Read .TXT file line by line? 12
How do I import a signed field into access data base? 1
Cant Import "-" as txt 2

Top