How can I filter records using DoCmd.TransferText

[colezpapa]

I am bringing in a rather large file via a
DoCmd.TransferText ... with an import specification file.
Is there a way I can filter out some of the records.
For instance, one of the fields is named "DOCUMENT". I would like to import only DOCUMENT type = "119"...Can I do that in this type of construct?

Thx

 

[Remou]

It is possible to link to text files, from there a make table query will allow the exclusion of any records. Is this what you had in mind?

 

[colezpapa]

Well, I thought there was somewhere I could provide a parameter...for example, when opening a form, you can do something like....
DoCmd.Openform "lastname = '" & strLastName & " ' "

 

[Remou]

No, there are no such options, just these:

http://msdn2.microsoft.com/en-us/library/aa164088(office.10).aspx