Wednesday, January 13, 2010 – Permalink –
Text Files to Excel
A hard way to do an easy jobText files can be imported or just pasted into Excel. If you want to learn more about SQL statements and non-code coding, look at this blog:
"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."
MSDN Excel Blog
See all Topics
<Doug Klippert@ 3:53 AM
Comments: Post a Comment