Recent content by deadlywonky

how do I make a transitional table, the help files are giving me squat.

Paul, all of the data imports, i can't reformat it into the date format i want. Severin thanks for the suggestion, however it hasn't worked, the format remains the same Tom

Hi Paul, I've just tried this and it's still coming out in the same format, using FORMAT (datestamp, yyyy.mm.dd) just brings up the enter date box as it did before

Hi Paul, i'm gathering data from about 50 sheets using the external data/ excel wizard. grouping into 4 queries because of 4 different formats, then grouping into 1 main query i'm not currently specifying a format for the column, so i guess it's coming in as general? i've tried using FORMAT...

Hi, I'm importing data from Excel where the date format is : [space]01Aug 12 I'm really struggling to transfer this into a standard date format (ideally yyyy.mm.dd). all the SQL functions I've tried don't work, I'd like to avoid having to reformat it in Excel (I need to keep the file size...