Using access with excel

[jloeff]

I have about 4 excel tables that have information both similar and unique. I would like to combine all 4 excel tables into one access database and then link all the information to together through multiple tables. Can anyone point me to the right direction?

 

[Terpsfan]

The first thing to do is get the data into Access. Create a blank database, give it a name, and then go to File--Get External Data...then in files of type, pick Excel. That will import the excel spreadsheets into Access. On the tables that are unique, find a column that uniquely identifies the column and set it as a primary key. Then you want to look at your tables in Access and determine what common fields you are able to link together and set the relationships between the tables. You might have to go back into the tables and change datatypes, because Access is going to arbitrarily assign what it thinks the datatype should be.