P
Phoenix
Hi,
1) I have a table in access (2000/2002) with project data i am working on.
When a new project comes i like to create a default set of folders (and for
the old projects to).
2) From these project tables i want to export to an excel worksheet and
there ad some variable colums (varies on the project and could well be some
20 or more).
I saw i that i can, from excel, make a query and import the data. The
problem is that as soon as i refresh the query the extra colums doesnt
correspond anymore with the records. (looked in properties of the query and
tried every option).
3) Lets say i would do the export from VBA (access) to excel. I want to
check IF a file allready exists, if not, create it and export data, if it
exists, open it and ad data.
Could anyone point me in the right direction here. I have some VBA
expirience but am not an expert so....
Txs in advance.
Phoenix
1) I have a table in access (2000/2002) with project data i am working on.
When a new project comes i like to create a default set of folders (and for
the old projects to).
2) From these project tables i want to export to an excel worksheet and
there ad some variable colums (varies on the project and could well be some
20 or more).
I saw i that i can, from excel, make a query and import the data. The
problem is that as soon as i refresh the query the extra colums doesnt
correspond anymore with the records. (looked in properties of the query and
tried every option).
3) Lets say i would do the export from VBA (access) to excel. I want to
check IF a file allready exists, if not, create it and export data, if it
exists, open it and ad data.
Could anyone point me in the right direction here. I have some VBA
expirience but am not an expert so....
Txs in advance.
Phoenix