Importing data

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

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
>
>

Fot the OP

Look also here
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Miguel Zapico" <MiguelZapico@discussions.microsoft.com> wrote in message news:F2110653-DBDC-4843-BF78-9C3AA55DD44C@microsoft.com...
> 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
>>
>>