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.
None.
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?
None.
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
None.
Why can't you just copy/paste the column over?
None.
Highlight column, ctrl + c, highlight column, control + v.
None.
yeah i've tried sorting it in the same order and then doing that
but with like 2000 people, it just made excel crash
None.
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.
None.
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.
None.
Which is why MySQL kicks ass.
None.
STF mod creator, Modcrafters.com admin, CampaignCreations.org staff