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


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

Importing data
 

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

Importing data
 

Fot the OP

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

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



"Miguel Zapico" wrote in message ...
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