Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word ![]() ![]() 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 excel <Doug Klippert@ 3:53 AM
Comments:
Post a Comment
|