You can use VBA, in this page you have an example:
http://www.rondebruin.nl/summary2.htm

Miguel.

"ATC18" wrote:


I'm building a datbase using Filemaker Pro for Macs. I can import data
from an Excel spreadsheet into the datbase pretty seamlessly. I would
like to send out an excel template and have people fill in the needed
data (names, phone numbers etc.) I would like to merge all this info
into one excel spreadsheet and then import it into my database. My
question is what is the easiest way to merge all the separate excel
documents (@400) into one document.

Thanks
ATC18


--
ATC18
------------------------------------------------------------------------
ATC18's Profile: http://www.excelforum.com/member.php...o&userid=36832
View this thread: http://www.excelforum.com/showthread...hreadid=565448