hi
i am a new member looking for some help in my problem
problem description:
i have to save .csv file as .xls after some opertaions
i opened the .csv file in excel through vb. then i converted it to .xls. i have a column named timestamp having the format yyyymmddhhnnss like 20050214094543 which i have to save after subtracting 7 hours in the same format
now i converted 20050214094543 to date format like 2005-02-14 09:45:43 using sql query and saved the file again successfully and set the column dataformat as custom yyyy-mm-dd hh:nn:ss . but the problem arises when i again access for subtracting 7 hours from the converted date ,sql query successfully subtracts 7 hours but on trying to save i get an error message while if i replace the same query with simple 'select * ... query without any date conversions it gets saved successfully. can anyone have a solution for my problem?it's very urgent