Fix Access 2016 Errors Linking CSV, TXT, and XLSX Files
Question details
The user needs to link CSV, TXT, and XLSX files to Access 2016 without an error.

- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Linking external text or Excel files to an Access database.
- Observed behavior
- Access displays “There is no object in this control” across multiple databases and file types, even after Office repair.
Have the exact error message and a sample CSV, TXT, or XLSX file ready for testing. Note when the problem started and whether an Office update was installed around that time.
Check the Access build and test the correct linking command
Use these checks to determine whether the error affects a specific file or a broader Access installation.
In Access, open File > Account > About Access and record the version and build shown. On the Account page, check whether Update Options is available.
Open a database and choose External Data > Text File. Browse to a CSV or TXT file and select the option to link to the data source by creating a linked table.
On the External Data tab, choose Excel for an XLSX file, then browse to the workbook and select the option to create a linked table.
Repeat the appropriate External Data command with another file and database. Record whether the same error appears and at which point in the linking process.

Review recent Office updates and contact Microsoft Support
Use this approach if the linking error started after an update or persists across files and databases.
Work with CSV and Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheet files. Its Microsoft Office format compatibility can help you move existing files between applications. WPS does not repair Access or replace Access linked tables.

Frequently Asked Questions
Where can I find my Access 2016 build number?
Open Access and go to File > Account > About Access. Record the version and build shown in the dialog.
Which command should I use to link an XLSX file?
In Access, choose External Data > Excel, browse to the XLSX workbook, and select the option to link to the data source by creating a linked table. Use External Data > Text File for CSV or TXT files.
What if the error occurs in several databases after an Office repair?
Test another source file, record your Access build under File > Account > About Access, and check whether the error began after an update. Share those results with Microsoft Support.
Can WPS Office fix Access linked-table errors?
No. WPS Office can open and edit CSV and XLSX files in WPS Spreadsheets, but it does not repair Microsoft Access or create Access linked tables.




