I have a complicated problem with tables.
I have a table in an access database that is linked to two excel spreadsheets (both are templates). one is used for input of the data. The scond is used to output the data to.
The problem occurs becasue i need to be able to create new tables within the database to store new sets of data. This requires somehow for a newe table to be created and any links to the templates to be also updated.
Does anybody know if this is possible or has anyone come accross a similar problem in the past?
I have a table in an access database that is linked to two excel spreadsheets (both are templates). one is used for input of the data. The scond is used to output the data to.
The problem occurs becasue i need to be able to create new tables within the database to store new sets of data. This requires somehow for a newe table to be created and any links to the templates to be also updated.
Does anybody know if this is possible or has anyone come accross a similar problem in the past?
