Recent content by Amylou007

Thanks everyone for the advice I have resulted to concating the data into one field using a query in editing it under the SQL window as follows SELECT CStr(Field1) + ",""" + CStr(Field2) + """," + CStr(Field3) + "," + CStr(Field4) + ",""" + CStr(Field5) + """," +...

Thanks for the suggestions....... The problem with the first method is that with in the file there are text fields that are required to remain formatted as such, with the " If I specify to remove this formatting it applies it to all fields and not individual ones and thus I can't use this...

Hi I currently have table that has a date field in the following format yyyy-mm-dd The problem is that when I export it to csv it becomes dd/mm/yyyy 00:00 I need the date to retain the format yyyy-mm-dd but the only way I can do this is to make it a text file prior to export. This is a...