This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi
In Access, I have a table that is linked to a .csv file saved on my hard disk. The .csv file has a header row, and when I built the linked table I had indicated that there is a header row.
There are several views built on this table.
In my source .csv file, I need to insert a column in the middle of existing columns. How must I go about changing my Access table so that the new column is recognized and all the other columns are appropriately shifted without having any impact on existing queries?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Scott
I will try to find how to run a manual link and check the input specs. In the meantime if you read this post and have some time to explain how to do it then please let me know, as I am not yet an intensive user of Access and so don't know how / where to find certain options.
Many thanks for your help.
Whenever I have a link to an external datasource (of any type, Access, SQL, csv or whatever) and make a structural change to the source, I now habitually DELETE the table link in Access, and use the External Data dialog to create a new link. It seems to be more reliable than trying to fix the link, and it's no more difficult than using the Linked Table Manager (which does NOT always catch the structure change).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Run a manual link and Check the Input Specification. That may have to be adjusted.
Hi Scottgem
Access picked up the "contents" of the column. But the heading was ignored. Also, it did not pick up the last column. So somewhere it has an image on the number of columns to pick up - and does not pick up dynamically each time all the columns.
Access will automatically pick up the added field in the CSV file. So you don't need to do anything to the linked table.
You will need to rewrite your queries to add the new field.