Thanks for the interest guys

I have been trying to open them via the open option in the file menu on the menu bar. This seems to be the only way to import dat. files??
Then when i had selected them all and gone through the import text screens, each file is imported as a seperate worksheet.

If there is a better way, id be happy to try it.
Is anybody able to supply me with the required vba code to import the entire contents of the folder into a single worksheet?

I would greatly appreciate it.