By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 1,980 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Importing Text Selectively

100+
P: 153
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
Jun 25 '07 #1
Share this Question
Share on Google+
1 Reply


pbmods
Expert 5K+
P: 5,821
Moving to the Access forum....
Jun 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.