[MOVED from Mobile]Program which reads data from an Excel file

[hanhan]

Hi all,
I need to write a program in VB.Net 2003 for the pocket PC (with mobile 5),
which will read data from an Excel file, and dispay them.
I didn't succeed to create a correct connection to the Excel file.
I tried few providers, as far as i tried the JET and OLEDB components are
not suitable to use on a pocket pc program (in vb.net).
there's the code:

Dim ds As DataSet

Dim con As IDbConnection

Dim comm As IDbCommand

Dim da As System.Data.IDbDataAdapter

Try
con.ConnectionString = "Provider=MSOLAP.2;Persist Security
Info=False;Data Source=c:\tblCity.xls;Client Cache Size=25;Auto Synch
Period=10000"

comm.CommandText = "select * from [tblCity$]"

da.InsertCommand.Connection = con
da.SelectCommand = comm
da.Fill(ds)

Catch ex As Exception
...
End Try

in the line of the connection initialization - the system stops and throw
the next error:
An unhandled exception of type 'System.NullReferenceException' occurred in
SmartDeviceApplication1.exe

I would like to get any advice...
btw - those are my first steps in the .Net Framework. sorry if the question
(and my code) is not clear/weird/etc....
Thanks!

[RedSon]

Unfortunately I am not a VB programmer so I will not be much help to you. But since this is a .NET program and the .NET compact framework is a subset of the available functions of a regular .NET program perhaps the .NET group can help you more.