Merge Excel Documents

[J.R.]

I am trying to merge multiple excel spreadsheets in regular or CSV format so
I don't have to copy and paste each and every file into one document. The
problem I am experiencing is that the "compare and merge workbooks" is not
highlighted and I cannot access that feature in Excel 2003. Does anybody
know how I can get access to that feature or recommend an altnerative
solution. Thanks.

-J.R.

 

[Bob I]

If the CSV files all have exactly the same fields and no headers, you
can do a "copy file1.csv + file2.csv + file3.csv allfiles.csv" at the
command prompt to concatenate them.

COPY /? to see usage particulars.

 

[J.R.]

Hi Bob,
thanks for the info. I take it you are talking about using DOS or
something similar since you mentioned command prompts.

 

[Bob I]

Command Prompt is the NT version of "DOS". You may find the shortcut to
start it Programs, Accessories.

 

[J.R.]

Do you have any idea how I can use the command within excel? I find it odd
that I cannot access the ability.

 

[Bob I]

No, not "within Excel". I gave you the simple way to do it at a command
prompt. If you want to do it from inside Excel, take a look at Data,
Import external data. Or you could record a Macro, or you could do it in
VBA. If that's the case, pose your question ove in the Excel group, and
be prepared to explain in detail what you want to do and the files you
want to do it with.

 

[Stanislav]

It is possible to take advantage of the special software for such purposes - MergeExcel



J wrote:

Merge Excel Documents
27-Aug-07

I am trying to merge multiple excel spreadsheets in regular or CSV format so
I don't have to copy and paste each and every file into one document. The
problem I am experiencing is that the "compare and merge workbooks" is not
highlighted and I cannot access that feature in Excel 2003. Does anybody
know how I can get access to that feature or recommend an altnerative
solution. Thanks.

-J.R.

Previous Posts In This Thread:

Merge Excel Documents
I am trying to merge multiple excel spreadsheets in regular or CSV format so
I don't have to copy and paste each and every file into one document. The
problem I am experiencing is that the "compare and merge workbooks" is not
highlighted and I cannot access that feature in Excel 2003. Does anybody
know how I can get access to that feature or recommend an altnerative
solution. Thanks.

-J.R.

If the CSV files all have exactly the same fields and no headers, you can do a
If the CSV files all have exactly the same fields and no headers, you
can do a "copy file1.csv + file2.csv + file3.csv allfiles.csv" at the
command prompt to concatenate them

COPY /? to see usage particulars

J.R. wrote:

Hi Bob, thanks for the info.
Hi Bob
thanks for the info. I take it you are talking about using DOS o
something similar since you mentioned command prompts


:

Command Prompt is the NT version of "DOS".
Command Prompt is the NT version of "DOS". You may find the shortcut t
start it Programs, Accessories

J.R. wrote:

Do you have any idea how I can use the command within excel?
Do you have any idea how I can use the command within excel? I find it od
that I cannot access the ability

:

No, not "within Excel". I gave you the simple way to do it at a command prompt.
No, not "within Excel". I gave you the simple way to do it at a command
prompt. If you want to do it from inside Excel, take a look at Data,
Import external data. Or you could record a Macro, or you could do it in
VBA. If that's the case, pose your question ove in the Excel group, and
be prepared to explain in detail what you want to do and the files you
want to do it with

J.R. wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips and Tricks No. 26
http://www.eggheadcafe.com/tutorial...be30-cde5d852348d/dr-dotnetskys-cool-net.aspx