470,586 Members | 1,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

Importing Text Selectively

153 100+
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.
Jun 25 '07 #1
1 1815
5,821 Expert 4TB
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.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
7 posts views Thread by Timothy Shih | last post: by
3 posts views Thread by Frustrated Developer via DotNetMonster.com | last post: by
5 posts views Thread by hharriel | last post: by
2 posts views Thread by Debbiedo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.