In the vb6, Which way is Get/Set the charset of Font CommoDialog ?

how to display image for datagrid

Can anyone please help me.. I have some data in excel (various columns and rows) and want to update cells (compare current value to a value in a database) and if the value is different I want to update the cell with the new value.. And then move onto the next cell and do the same thing again..

EG:

A B C D E F G
1 paul now tar 16 21 35 34
2 ian now bricks 32 45 2 90

So I want to compare cell D1 with a value in a database based on the criteria of cells A1 and C1.. Then move onto E1 etc..

After the whole row is complete move onto row 2 and compare cell D2 with a value in the databse based on the criteria of cells A2 and C2.. THen move onto E2 etc..

Ma:
You can't do it by Font CommoDialog , You can use the ChooseFont API to retrieve the charset information ,ChooseFont opens the Choose Font common dialog box. All of the necessary information needed to create the dialog box, as well as all of the information returned from it, is stored in the structure passed as pChooseFont. The logical font information is mostly stored in a LOGFONT structure, which can be used to access that font.
you can reference the code written by me:
http://www.blanksoft.com/article_read.asp?id=134

zzang:
datagrid does not support images directly. You can do this with the
MSHFlexGrid as each cell has an Image Property

hi Kyle ,
You could do something like this:
set oSheet = xlapp.ActiveSheet
cellRows = 2
cellCols = 4
for i = 1 to cellCols
for j = 4 to cellRows
if somevalue<> oSheet.Cells(i,j).Value then do something
Next
Next

I am a relative beginner. I have an excel spreadsheet open and I wish to update a table in a sql database with the values in specific cells of the excel sheet using VB6..


SPREADSHEET:
A B C
1 Paul Kruger 21

SQL DATABASE:
Table: Person
Fields: First, Sur, Age

For example I want to "select age from person where first = 'cell A1' and sur = 'cell B1'.. I then want to update that found value with the value in 'cell C1'..

Thanks for youe help in advance