The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.
- Reading and Writing Text Files using TextStreams (this blog)
- Creating a Text File and Writing Lines
- Reading in Lines from a Text File
Posted by Andy Brown on 13 January 2012 | 2 comments
Reading and Writing Text Files using TextStreams
This blog shows how to read from (and write to) text files using something called TextStream objects.
There is another way to do this in VBA using commands like Input and Open, but I think the way shown here is much easier to remember and use.
In order to get any of the code in this blog to work, you first need to create a FileSystemObject.
This blog has 2 comments
1. can I install specific part of SQL Server, (e.g. Client Tools,...) on a PC? (considering that I don't need all of SQL Sever package, but only the ability to import data and filter what I want)
2. if I have to install the whole package, is it possible to install it on a PC?.. can you provide me with a link to help me achieve that goal?..
3.any other way?
thanks in advance...
1. I'm not familiar with VBA, so I kinda trying to find a way around it... (i.e: doing what I said above, without VBA).
2. this DB (which is actually one table) has more than 10 million records ...
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.