larry,

thanks for the help, pls allow me to extend my question, okay i have to emptyed the recordsource property but how to connect a certain object like MSdatagrid to the ADO control in which MSdatagrid control needs a datasource...my real problem is that how to display the excel data into msdatagrid control...

holden