Reading an Excel spreadsheet into a dataGrid

geor68

New member
Joined
Nov 6, 2011
Messages
4
Programming Experience
Beginner
Hi,

I have successfully read a complete Excel spreadsheet into a Datagrid. Is it possible to only read part of it in? If so, how?

Regards

geor68
 

niceastham

Member
Joined
Mar 18, 2011
Messages
11
Programming Experience
1-3
Are you using the oledb to read from excel? If so, then simply change the select statement to use only the columns you require.
 
Top Bottom