combine 2 files into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello, I am facing difficuties to combine 2 files into one excel file
These 2 file consist about 80,000 rows.

Need your help urgently and please advice.

Thank you.
 
Unless you're using xl2007, you're going to have trouble.

xl97 to xl2003 only support 64k rows per worksheet.
 
Hi Dave,

Thanks, i am using Xl2003 how to combine the 2 files if the rows are less
than 64K
 
Import each to their own worksheets in separate workbooks. Then copy|paste from
one to the other.

Or if the files are text files, merge them together using your favorite text
editor and just import that giant file once.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use a percentage formula? 2
Merge 2 datasheets into single Pivot Table. 2
combine multiple rows in one column 3
How can I combine several excel files into one? 1
How to combine several successive rows into one cell 2
accounts receivable spreadsheet 1
List Management Question- Combining into one 2
How do I combine the contents of two columns? 4

Back
Top