G
Guest
I have hundreds of existing spreadsheets that I want to gather into a DB.
Basically it is a form that project managers fill out and return with info on
their projects. I created a schema and mapped elements to cells on one of the
existing forms. This worked great when I imported the XML in Access. However
I discovered that when I import the schema into another spreadsheet the map
does not follow and I have to map every cell again in every one of those
hundreds of spreadsheets. Is there a way to automate this or to apply a map
to the other spreadsheets? Thanks.
Basically it is a form that project managers fill out and return with info on
their projects. I created a schema and mapped elements to cells on one of the
existing forms. This worked great when I imported the XML in Access. However
I discovered that when I import the schema into another spreadsheet the map
does not follow and I have to map every cell again in every one of those
hundreds of spreadsheets. Is there a way to automate this or to apply a map
to the other spreadsheets? Thanks.