To exchange data between Excel and Access,the data must be exported into a text file and then imported.

Question

Quizplus · Accepted Answer

Excel and Access have built-in features that allow for direct import and export of data between them without the need for intermediate text files. For example, in Access, you can use the "Import Excel Spreadsheet" wizard to import data from Excel, and in Excel, you can use the "Get External Data" feature to import data from an Access database.

To Exchange Data Between Excel and Access,the Data Must Be