Hi,

Trying to write a macro to import consecutively named .xls files into the same table.

Any ideas on how to do it?

thanks

No worries, this works




http://www.access-programmers.co.uk/forums/showthread.php?t=61390&highlight=import+multiple+files