importing multiple text files into Excel with corresponding filenames

Dear members,

I need to import 100+ text files into Excel.

In addition I want EACH Excel column to show corresponding filename
too (where the data comes from).

How do I accomplish this?
TIA

Correction:In addition I want EACH Excel ROW to show corresponding

Correction:

In addition I want EACH Excel ROW to show corresponding filename
(where the data comes from).

instead of

Files are comma delimited

Check out your other post. There is no need to multi-post .--Jacob"avi" wrote:

Check out your other post. There is no need to multi-post .

--
Jacob