Hi,
I have an XML file of data that I want to import into access 2007 to be a lookup table. The table will contain an ID, Name. To create this xml file with just ID Name I need to import using a Xslt template. This works great the first time and I save my Import to be used later. The following are issues I'd like to solve but am not sure how.
1) When I use a template file with my saved import I can never run that saved import without an error.
2) When you import an XML file again you have an option to append the data to the same table, but it doesn't seem to allow you to replace the table. So does that mean I need to delete the table before doing the import?
3) Is there any way to set it up to have Access automatically reimport this XMLData if my source XML File has changed?
Thanks for any advice on these issues
Keith
I have an XML file of data that I want to import into access 2007 to be a lookup table. The table will contain an ID, Name. To create this xml file with just ID Name I need to import using a Xslt template. This works great the first time and I save my Import to be used later. The following are issues I'd like to solve but am not sure how.
1) When I use a template file with my saved import I can never run that saved import without an error.
2) When you import an XML file again you have an option to append the data to the same table, but it doesn't seem to allow you to replace the table. So does that mean I need to delete the table before doing the import?
3) Is there any way to set it up to have Access automatically reimport this XMLData if my source XML File has changed?
Thanks for any advice on these issues
Keith
