I am new to making database but i done a lot of Programming Before. I teached myself Access 2010 and have built a Database for a Small Company.
Now they have got previous Names and Details saved in Exel Files.
What would be the best way to integrate them into Access? Should i change the Exel files so they look the same as the table i designed in Access and then Import them? And once I Imported them should i leave them in a separate Table or add them all into one BIG table?