L
Lars
Hi
I have a boatload of xml files which I am importing into Access 2007. A
number of fields in the Tables are Date/Time. In my xml files I have i.e.:
<event_stop>14.06.07 hour 15:00</event_stop>
The label 'event_stop' is also the name of the field in my Access table,
which I should import this to.
- How do I best import this so that the values are Date/Time and converted
properly?
- What is the format that the String version of the dateTime should have to
be correctly interpretted by Access.
- Where should I perform any conversions?
I use an xslt file to reconfigure the xml files upon import and have a vba
rutine to import all xml files in a user selected folder.
Regards,
Lars
I have a boatload of xml files which I am importing into Access 2007. A
number of fields in the Tables are Date/Time. In my xml files I have i.e.:
<event_stop>14.06.07 hour 15:00</event_stop>
The label 'event_stop' is also the name of the field in my Access table,
which I should import this to.
- How do I best import this so that the values are Date/Time and converted
properly?
- What is the format that the String version of the dateTime should have to
be correctly interpretted by Access.
- Where should I perform any conversions?
I use an xslt file to reconfigure the xml files upon import and have a vba
rutine to import all xml files in a user selected folder.
Regards,
Lars