datagrid bind with microsoft excel

[albertkhor]

in vb.net is there any easy way to import microsoft excel field into datagrid? can someone teach me how to code it?

 

[albertkhor]

i have successful bind my listview with my database (microsoft excel) but the problem is the system do not know when it need to stop to get the data in the field, this will make the system crash.

i only can bind my data with listview by setting the column and row i want, example:"select * from [Sheet1$A1:Z6]". The problem is if user input more than 6 data then my system will cannot get the value from excel! Can someone help me?