Hello,
I have written an append query to import data from a linked CSV file into a table in an Access Db in week and month ofrmat. When I try to import the data in using only the month format (using 'exp:format(field2, "mm yyyy")') it works fine but when I have added onto to the query to add the week and year format (using 'exp:format(field2, "ww yyyy")') I get a data conversion error on most of the data coming from field2 in my file. If I continue to import all the records are set to null.
The month column comes with the desired 01/01/2005 for all dates based in January 2005. I tried importing just the dates from the files and doing a query on these base dates to get the weekly figure but the problem is that an output of 12 2005 and 13 2005 rather than the desired format 14/03/2005 and 21/03/2005.
I have checked that the field in the linked file is set to a date/time format. Can anyone suggest why this happening and how to get around it!!
Thanks
I have written an append query to import data from a linked CSV file into a table in an Access Db in week and month ofrmat. When I try to import the data in using only the month format (using 'exp:format(field2, "mm yyyy")') it works fine but when I have added onto to the query to add the week and year format (using 'exp:format(field2, "ww yyyy")') I get a data conversion error on most of the data coming from field2 in my file. If I continue to import all the records are set to null.
The month column comes with the desired 01/01/2005 for all dates based in January 2005. I tried importing just the dates from the files and doing a query on these base dates to get the weekly figure but the problem is that an output of 12 2005 and 13 2005 rather than the desired format 14/03/2005 and 21/03/2005.
I have checked that the field in the linked file is set to a date/time format. Can anyone suggest why this happening and how to get around it!!
Thanks
