so i have 2 databases with information in them

one of them has this : primary key# : Name : players position : age :

i have another database that has more info to add to that; so it has : primary key# : players stats :

now i want to put them together into 1 database so that it shows : primary key# : Name : players position : age : players stats:

and i cant do this manually because i have a list of about 2000

so how can i do this?

Post has been edited 2 time(s), last time on Feb 1 2009, 4:21 pm by Toothfariy.

I've never used Excel database, but is there a 'merge' option or anything like it? I've used MySQL and I do believe there is a keyword you can use to do it.. Anything like that in Excel?

i cant find anything for merging in excel

and its just a spreadsheet thats being used as a database (idk why tho)

i believe microsoft access has some kind of feature that can do this better but i have no idea what it is or where to find it

Why can't you just copy/paste the column over?

Highlight column, ctrl + c, highlight column, control + v.

yeah i've tried sorting it in the same order and then doing that

but with like 2000 people, it just made excel crash

Then do it in blocks of 500 or something.

Save both files as 'Comma Separated Value' files (.csv), give them to me and tell me what the order is on the values. I'll load them into mysql, join them by query, and I can give it back to you in either .csv or an excel 2000 file.

Which is why MySQL kicks ass.

Tool: http://www.merge-excel.com/
Tool: http://www.ozgrid.com/excel-add-ins/merge-tables.htm
Tool: http://www.softpedia.com/get/Internet/Servers/Database-Utils/Excel-Join-Two-Tables-Software.shtml

VLOOKUP: http://en.allexperts.com/q/Excel-1059/Merge-excel-database-sheets.htm

MS Access: http://lists.evolt.org/archive/Week-of-Mon-20041025/165694.html