I may have misunderstood your request.
If you have manually entered values in Col_C, the data import will overwrite
them with blanks or move Col_C over to the right, depending on the table
options you select. There's no way to have the data import fill columns A,
B, and D without impacting Col_C, if that's what you were hoping for.

There may be other possibilities, via MS Query...depending on the specifics
of your structure.

Can you describe how you use (or hope to use) the data?
***********
Regards,
Ron

XL2002, WinXP


"chinna sankar" wrote:

Hi Ron

Thanks for the reply. I have already title under column D
But the data is sitting under column C after the query.
The column D is shifting right side.

Do you have any suggestion on this?

Thanks
Chinna



*** Sent via Developersdex http://www.developersdex.com ***