Text Files to .xls

[DShilan]

<HR style="COLOR: #ebebeb; BACKGROUND-COLOR: #ebebeb" SIZE=1> <!-- / icon and title --><!-- message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->I am running a SQL query that produces a txt file for each day of the year (much faster than running for the year as a whole).

How can I select all of these .TXT files and drop them into a single Excel Worksheet?

Filenames are

BT_01-Sep-10.txt
BT_02-Sep-10.txt
BT_03-Sep-10.txt

etc

And are saved here: C:\Documents and Settings\234641\Desktop\New Folder


Thanks.

Or if i rename them all as .xls, is there a way to make all the data from the different workbooks, appear in just one worksheet?

Dan
<!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[Weaver]

If you're going to rename .txt files so that they open directly into Excel, use .csv rather than .xls.

As for making them all appear in one workbook or worksheet, you'd need to run some xl vb code to import the date fromeach file into common workbook/sheet, although this could be relatively straightforward.

HTH

 

[DShilan]

Anybody able to assist with VB script for this?

 

[rpaulson]

Some inf here.

http://www.rondebruin.nl/csv.htm