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
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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.