Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What function do I use to link data from a .txt file to Excel?

Status
Not open for further replies.

dimshen

Programmer
Joined
Oct 6, 2008
Messages
1
Location
GB
I have a large amount of data to manipulate in .txt format.

i want to be able to specify sections of data from the text file and import chunks of it into excel for further manipulation.

What VB function can i use to do this??

Many thanks for nay help!
 
Are you explicitly trying to avoid reading through the text file line by line to determine which data is wanted?

Your question implies you want to do something a bit more complex, perhaps because you have a very large file.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top