Merging incoming Excel files((

[narna]

Hello

Am not at superuser in Exchel, so I need som help.

I have a Excel 2010 on a Windows 7 computer.

Every day I get an csv file (test.csv) with the same content, just that they added some more lines.

How can I merge this new file every day to my already test.csv (automatic if posible) Now I haft to do this manuell.

Is it posible?

Ntest.csv

[FDibbins]

Hi and welcome to the forum

If all that is happening is extra data is being added, why merge them? Just over-write the 1st set of data with the new data?

[narna]

Hi, and thanx

Well - yes, sort off hehe.

I have a csv file with about 1.million rows. And for each day, I get a new file - with new rows. Not sure, but between 50 - 100 new rows each day.

The file is named the same as the first csv file.

And I want all of the data inside, not just the new ones

Not sure if you understand me here

[humdingaling]

so you want to keep all the data you have original but add all the new lines every day?

so in fact you are appending your file new files

would this non excel solution work?
http://www.solveyourtech.com/merge-csv-files/

the excel solution is a lot more complicated requiring some VBA knowledge

[narna]

Hi

I want to keep all my data yes. just add the rows that comes in every day - in the first csv file

Maby appending is a better word than merge

Hmm not sure. Going to test now .

[narna]

Well - it went okey.

I have to files. First file have 80 rows (test001.csv) the second file test002.csv have 57 rows.

When I rund the - copy *.csv allofthem.csv I only get the rows from teste001.csv. Rows in test002.csv are not beeing copyed.

I would like the result to be like the file allofthem.csv

allofthem.csvtest001.csvtest002.csv

[humdingaling]

hmmmm the only difference i get is that allofthem is cleaned up due to test 001 having many ";" lines at the bottom

so you want a process to clean it up after combining?

Please Login or Register  to view this content.

open csv and run this code
it should clean up any lines that behind with ;;; <<you can add detail more if you want to be more specific

[narna]

notthis.jpgHi

Very nice - works like a charm

One thing thoug.... how can Remove the first line.