Add field to Linked CSV

[memaxt]

Hi All,

I currently have a CSV Table consisting of 30 fields linked to my access database, now and again I need to add additional fields. but each time I do this I'm having to relink the csv and rename all the field names etc..

Is it possible for me to add a new field directly in the CSV files and quickly refresh the linked table in access to pick up the new field? I've tried the Table Linked Manager. but it doesnt pick up the new field

[NTC]

a csv text file requires an explicit link set up because of the variability of its potential content.

you should open the csv as an excel file, and then save it as an excel file - only takes a second......then link to that excel file....I believe, though am not 100%, that an excel file will act more like a table where you can add a column/field name and just refresh the link rather than remake it.......