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

[June7]

None that I know of.

[hapm]

What happens if you only refresh the table using the table link manager? If it works, you cna write a small vba script that does the link refresh on db startup or in your import script. This will only refresh the table definition, if you use some of the dynamic field in querys, the querys will be broken as long as the given field doesn't exist in the excel file.