Login to Excel?

[hog]

Login to Excel? (modified)

 

I read an xls file into a dataset and use this dataset as the ReportSource for my report.

 

Every thing works fine until I get a Logon to Database prompt?

 

The xls file is c:\returns.xls

 

In the login window it states the following:

 

Table = Returns_

 

Server Name c:\returns.xls

 

Database = c:\returns.xls

 

If the ReportSource is a dataset why am I being prompted for a logon??

 

Any ideas:confused:

Edited July 5, 2003 by hog

[hog]

For your info:

 

The following produces the logon box?

 

myCommand.Fill(datasetname)

 

whereas this does not??

 

myCommand.Fill(datasetname, tablename)