Hi,
I'm trying to create a program that imports a file im receiving from another department and after 3 months of back and forth trying to get the file in a format that is easiest to work with i've given up (can you tell i'm bitter?).
I'm just going to use what they have given me and i've made almost everything work. The one thing i'm left with is i want to run an Update Query to change a medium date format to a short date format.
the format i've been given is "23 Sep 2010" without the quotes but regardless i'm importing it as text which gives me records that look like:
23 Sep 2010
i know i can use VBA to put all the fields into an array then run through the array changing the format but i want to do this in possibly the easiest way which would be straight through an update query.
if anyone could help me format a update query to accomplish this it would be greatly appreciated.
~Thanks
I'm trying to create a program that imports a file im receiving from another department and after 3 months of back and forth trying to get the file in a format that is easiest to work with i've given up (can you tell i'm bitter?).
I'm just going to use what they have given me and i've made almost everything work. The one thing i'm left with is i want to run an Update Query to change a medium date format to a short date format.
the format i've been given is "23 Sep 2010" without the quotes but regardless i'm importing it as text which gives me records that look like:
23 Sep 2010
i know i can use VBA to put all the fields into an array then run through the array changing the format but i want to do this in possibly the easiest way which would be straight through an update query.
if anyone could help me format a update query to accomplish this it would be greatly appreciated.
~Thanks
