Thread: Modifying linked tables in Access

This is correct, you can't modify the data type in a linked table.

If you're having diffculties making Access pick the right data type, here are some suggestions.

First, delete the link from Access. Then in Excel make sure the first row (if you have headers then the first row below the headers) contains the right sort of data in each column and save. In Access now link to the Excel file. Hopefully now it's picked the right data types. Don't forget to put your Excel file back as it should be.

If this hasn't worked, try setting up a new Excel file with just one row (+ your headings if you have any) with data in each column. Link this into Access and see if it's got the data types right. If it has, go to Linked Table Manager and relink the table to the Excel file with your data in it.

Alternatively, if your Excel file can be a csv file instead, you have more options. To set this up, open you Exel file, go to Save As and change the file type to *.csv. This will still open in Excel in the same way, but some formatting may be lost. Then in Access link to this csv file. When you go through the linking routine, you'll have the option to choose the data types manually.