Friday, September 30, 2005 5:33 AM
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...
Friday, September 30, 2005 5:43 AM
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
Paul June A. Domag
Friday, September 30, 2005 1:44 PMHi,
I did it and nothing... The wizard shows the same error...