| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Linear Mode
