A companion article, Microsoft Access versus Microsoft Excel, has been posted a month ago, for comparing the two and discussing the differences of each product. But that doesn’t mean you need to choose between one or the other. There may be times that you would want to take advantage of the benefits that both programs have to offer. When using the Office family of products, you can always utilize the option to integrate two products; hence, marriage between Excel and Access makes lots of sense. When to move (migrate) Excel data into Access If the Excel worksheet has become too large and complex, other users working in the database and you want robust options that safely handle updates to your data, need to add more tables to a data set that originated as a flat or non-relational table Want to import or link your worksheet into Access and use it as a database instead of working with it in Excel. Want to run complex queries. Want to produce a variety of reports or mailing labels. Have entry forms to provide a more convenient interface and ensure that only the correct types of data are entered. Import (migrate) data from Excel to Access The word “import” means, you bring data into Access once, but without a permanent data connection. When you import data, Access stores the data in a new or existing table without altering the data in Excel. The Import Wizard in Access walks you through the import steps and helps you. Alternatively you can copy data from Excel and paste it into Access. Access automatically asks you few questions and creates an Access table