vishal anand.s 0 Newbie Poster

hi my name is vishal
i am using vb6 as front-end and ms access as back-end.I dont want to use data report instead i want to export all these multiple tables values to excel into a single sheet.I am using a command button and whenever i click that command button i want it to show all the combined fields into single sheet in ms excel. Can anyone help me please?