File Format & Compatibility

Fix Access 2016 Errors Linking CSV, TXT, and XLSX Files

Steven ParkerSteven Parker Nov 18, 2026 868 views

Question details

The user needs to link CSV, TXT, and XLSX files to Access 2016 without an error.

Fix Access 2016 Errors Linking CSV, TXT, and XLSX Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Record the build

In Access, open File > Account > About Access and record the version and build shown. On the Account page, check whether Update Options is available.

2
Test a text file

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.

3
Test an Excel workbook

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.

4
Compare results

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.

Check the Access build and test the correct linking command
If Office was already repaired: If different files and databases still fail after an Office repair, check whether the problem began after an update rather than repeating the same repair immediately.
Free Microsoft Office alternative

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.

Open and edit CSV data in WPS Spreadsheets.Work with Microsoft Excel XLSX files for easier file migration.Use a familiar spreadsheet interface.Get a free, lightweight office suite.
microsoft office alternative - wps office

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.