I'm just starting to dabble in databases and I'm a little lost.
I have a couple of questions:
I have two excel spreadsheets containing employee records & equipment records respectively. For MS Access, I simply import these spreadsheets into MS Access. Is this the way to do it on mysql and other dbrm apps (importing data from spreadsheets) or is there some other standard way ?
What are the common ways to create the tables that are worked on in dbrm apps ?
I googled and it seems that everyone creates the tables using scripts and not spreadsheets ... so how do we input chunks of data (ie. 120 employee records) into these tables ?