Hey guys,
I'm fairly familiar with access by now, but I've never worked with importing text into an access database. I have some fairly large text files (lets say, for example, a folder of 20 text files could be about 120 mb with each text file being 6 mb). I know that Access has some strict limitations on fields and their sizes and I've learned to stay away from using memos. The files are encoded health files and so they have a '~' to represent a new line. I can import by lines which would rarely have lines greater than 255 characters, but this would involve a lot of importing. The point of the program is to find different elements of a file...these elements can easily be found by running a find command (ctrl + f) and searching for the segment the information should be found within. I'm wondering, therefore, is there a way I can search through an external string of very large length (such as 100's of megabytes) and only import matches or create a count of how many times the search comes up with the desired result? I am only wondering for specific code or some commands I could use. I am familiar with how I would access the text file or import it...plus there are already threads referring to that. I would do this all from the VBA side of things. Any help would be greatly appreciated. Thanks.
Cheers,
Kosmös