Guest Stanislav Posted March 6, 2010 Posted March 6, 2010 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: On Monday, August 27, 2007 10:30 AM J wrote: 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. On Monday, August 27, 2007 3:13 PM Bob I wrote: 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: On Monday, August 27, 2007 9:14 PM J.R. wrote: Hi Bob, thanks for the info. Hi Bob, thanks for the info. I take it you are talking about using DOS or something similar since you mentioned command prompts. "J.R." wrote: On Tuesday, August 28, 2007 2:53 PM Bob I wrote: Command Prompt is the NT version of "DOS". Command Prompt is the NT version of "DOS". You may find the shortcut to start it Programs, Accessories. J.R. wrote: On Thursday, August 30, 2007 9:32 AM J 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 odd that I cannot access the ability. "Bob I" wrote: On Thursday, August 30, 2007 10:38 AM Bob I wrote: 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/tutorials/aspnet/8e390106-20d1-4b2b-be30-cde5d852348d/dr-dotnetskys-cool-net.aspx Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.