Dynamic Columns - Import new columns?

[memaxt]

Hi All,

Hope you can help

I have linked an excel spread sheet to a database. Where set columns are imported.

The problem
The website where they submit information has an option where they can add unlimited additional fields (dynamic field) this is a required i'm afraid

Is there a way of linking the excel spread sheet to the database where it will automatically recognise new columns? Without having to constantly relinking the table?

Many thanks
Max

 

[CJ_London]

providing your linked table is not limited to a range then it should just 'see' the extra columns. You just need to ensure the workbook has the same name and is in the same location