Host your Web site with PureHost! |
![]() ![]() Wednesday, January 13, 2010 – Permalink – Text Files to ExcelA 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 Labels: Excel <Doug Klippert@ 4:51 AM |