05-27-2008, 01:43 PM
|
#1 |
|
Old Skooler Numba 1
  
Join Date: Nov 2000
Location: Diego
Posts: 10,063
 |
Merge excel spreadsheets?
Hey everyone. I have a Filemaker database that when it exports records it creates multiple excel sheets. Our statistician cannot import the data into Statistica as multiple files. I was looking into an application that will allow me to merge them all. Does anyone have any experience with this? If so, is there an application that you would recommend?
Thanks in advance.
__________________
~~~~~~~~~~~~ 3 days ~ Willie Nelson 3 days I dread to see arrive 3 days I hate to be alive 3 days filled with tears and sorrow yesterday today and tomorrow |
|
|
|
05-27-2008, 02:10 PM
|
#2 |
|
Chief of Naval Operations
Join Date: Aug 2002
Location: raising my pimp hand strong
Posts: 13,038
|
does it do so because it would exceed the field limit? if so, i don't know of any way to do it.
__________________
70% of the world is covered by water. The rest is covered by Bob Sanders |
|
|
|
|
05-28-2008, 01:01 AM
|
#3 | |
|
Old Skooler Numba 1
Join Date: Nov 2000
Location: Diego
Posts: 10,063
|
Quote:
The reason that it exports into separate sheets is because of the design of the database. Dumb, I know. But the sheets aren't that big. Let's say sheet one has 20 columns and sheet 2 has 30 columns. I like to make one sheet with 50 columns. What would you use for that? |
|
|
|
|
|
05-28-2008, 05:42 AM
|
#4 |
|
Fleet Admiral
 
Join Date: Mar 2000
Location: Michigan
Posts: 9,390
 |
Copy & paste?
 Unless, of course, you're working with just tons & tons of files. In that case, hire an intern to write a VB program to do it. |
|
|
|
|
05-28-2008, 04:31 PM
|
#5 |
|
Old Skooler Numba 1
Join Date: Nov 2000
Location: Diego
Posts: 10,063
|
Thanks everyone. I'll let you know if I find something.
|
|
|
|
Linear Mode
