Thanks for the replies...........
See the thing is dont want to use the wizard.........
i want to do it programatically...........
What lisa said, i have been researching on it........... but for the sorting and
all, i have to do it manually before i can import  in to access........
which is not possible...........
so i was thinking some sort of code to be written which can do taht for
me........
Dawn thanks for telling me about blank rows, i never knew about that.......
but still i will request you guys to suggest something else, which will require
the least interaction and the import will be automated.........
Really thanks a lot for ur responses.........
i am still waiting for more guidance from the group..........