Typed Dataset from Excel

Question

Hello,

I need to create a typed dataset from a excel file and I must use the .NET Framework Data Provider for OLE DB.

The Data Source Configuration Wizard reports an error on the last step, in which I'm supposed to choose the table from the file's structure.

Error Text: An error occurred while retrieving the informartion from the database. Operation is not supported for this type of object.

This is the connection string from the Wizard:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="file.xls";Persist Security Info=False;Extended Properties="Excel 8.0"

Is it a bug or is not really supported?

Is there a workaround? I tried ODBC Provider and the Wizard worked fine but this is not an option...

Thanks,

Rolando./

Answer 1

Hi,

You must specify Names in the workbook. Take alook on this link on how to do this. http://support.microsoft.com/default.aspx?scid=kb;en-us;311731

 

 

cheers,

Paul June A. Domag

Answer 2

Hi,

I did it and nothing... The wizard shows the same error...