Microsoft Excel Blog: Append multiple text files into a worksheet without code

The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.

Append Multiple Text Files into a Worksheet without Code

Summary:     Shows how to append multiple text files into one worksheet through the user interface (and without using VBA code) by changing connection string information to an SQL UNION statement.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language