show excel file on form

[WeeBeng]

I have data on an excel file. What is the most effective way to show it on the form. I tried using MSFlex grid and then using a data control to bind it to the excel file but some rows of data were not displayed. How can I do it?

Thanx

[Johnny101]

if all the clients will have Excel installed on their local system, you can use the OLE Container and just point to the file. Excel will then load up in your app's process and display the worksheet.

otherwise, you'll have to figure out what's wrong with the data access code and why your data isn't showing.

good luck,

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org