Database Merge Tool

Suggestions for tool to merge records in two or more files.

[erika1959]

I have 2 .csv files whose contents I need to merge.

The merge needs to happen horizontally; that is, I have five fields per record in file A, and three fields in file B. I need to merge so that each record has eight fields per record.

I'm able to link or pair up the records contained in one file to another, since both files share one field in common - the product number.

While it would be theoretically possible to manually add the fields from one file to another, it's not really an option, since I have over 5,000 records to edit.

I'm desparate to find a utility/tool that can undertake this type of editing - anyone know of one?

If there's any problem with naming individual software applications here, I'd really appreciate it if you could sticky mail me with your suggestions.

Thanks in advance,

Erika

[coopster]

I don't know of a tool or utility off hand, but I can think of a couple ways you could do this...

One would be to create the table structures in a database and use query statements to merge the two.

Another option would be to use spreadsheet tools to do table lookups to join the two tables and save the joined information as a new .csv file.

[erika1959]

Thanks Coopster - an acquaintance kindly offered to do a lookup and merge for me.

Regards,

Erika.