Recent content by tawkkal

i also have doubt regarding time... i have file which contains data with time.. which is calling time.. now when i want to apply filter in query using > 10:30 AM or 10:30 i dont get the output correct.. many times the out put is no records.. can u help me...

fyi... if it is in access.. i might have linked the excel file to access table... This way i can use delete query in last procedure after the files are transfered to respective tables... As the original file is excel & is linked to access delete query will erase the entire data from there...

fyi... i receive file in csv format ... which i import to access. for doing this... i first import the file in excel... & then transer the same to access.. by doing this i m able to cross check if every thing is working fine or not.. while importing in excel i can notice if there is any error &...

hi.. friends... I m access user... i have made some queries.. & want to transfer data from different queries to on excel file in different sheets.. I have tried transfersheet macro... but... it transfers with one inverted coma in text column.. due to this the data exported to excel is no use...