Creating Date time stamp on import of XML

[herbc0704]

This is a little over my access pay grade so I figured I ask here in the forum.

I have xml tables that I am importing into an access table on a daily basis. The tables are for the previous days transactions processed but the table does not contain a processed date. Is there anyway to add a date/time field that is equal to the time of the import into access? Or are there any other suggestions that are out of the box that I have not thought about.

 

[revans]

Import your data into a temp table then run an append query into the "real" table. The the append query can include a custom field that has the date.

hth,

Rich