By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,761 Members | 1,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,761 IT Pros & Developers. It's quick & easy.

Import Date from XML

P: 9
--------------------------------------------------------------------------------

Hello
I am sorry for the German version. Here is my question in English:
I am importing from an XMl file into an existing Access database. There is one line in the XML file
<datum>12.03.2006</datum>
The value should be imported into a column which is datatype date. After the import the value in this column ist 00:00:00.
If I change the datatype to text the date is correct. But I need the datatype date for sorting.
I appreciate any help.
Regards
Heinz
May 22 '07 #1
Share this Question
Share on Google+
3 Replies

Rabbit
Expert Mod 10K+
P: 12,441
The format is wrong for an Access date, the . should be /
What you can do is import it as text and then have a query that replaces the . with /, converts it to a date, and then appends it to a different table.
May 22 '07 #2

P: 9
Thank you. I'll try it.
May 24 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
Thank you. I'll try it.
Good luck.

BTW, the function to convert a string into a date is CDate(). But the string has to be in a date format first.
May 24 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.