In this case, you’re not going to use the Text Import Wizard. ![]() Each file has the same number of columns, the same column headers for each column, and the same type of data in each column. 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.
0 Comments
Leave a Reply. |