Selective Text Import

[mgilbert86]

Hello,



I have an issue coming up with file size for a text file being used in our databases. Is there any functionality that exists inside of Access to import selective data from a text file instead of the entire record set based on criteria? For example, I would only need lines where one of the fields meets criteria of containing "Brown*"...

[JoeM]

It can be done, but it is a bit trickier, as it usually involves using VBA, and looping through RecordSets.
Here is a link of one such example: http://stackoverflow.com/questions/1...mport-csv-data