The only way to exchange data between Excel and Access is to export the data into a text file and then import that text data.

Name: The only way to exchange data between Excel and Access is to export the data into a text file and then import that text data.
Brand: Quizplus
Rating: 4.9 (24 reviews)

Question

Quizplus · Accepted Answer

Excel and Access can also be linked, allowing for real-time data exchange through a direct connection or by using a shared ODBC data source. Data can also be copied and pasted between the two programs.

The Only Way to Exchange Data Between Excel and Access