You have three CSV text files containing sales data, Beverages.csv, Condiments.csv, and Confections.csv. There’s a way to do it in Excel by using a simple SQL statement in the connection string. Do you have to use Access or VB code to solve this problem? No.
From time to time I hear customers asking how to do this in an easy way. Today’s author: Mark Gillis, an Excel and SharePoint writer, who’s been through six versions of Office, survived to tell the tale, and picked up a thing or two along the way.Įxcel doesn’t have an easy way to append multiple text files into one worksheet through the user interface.
