SQL Excel

Hi,

Getting Error while opening the sql promt..

Errr - Object Or Provider is not capable of performing requested operation (QUIKLOAD)


my whole database is in excel.. so how cud i connect that database and get some result from tht... pls let me know

Thaks,
Manoj

Hi !

I found this article after searching on Google
http://support.microsoft.com/kb/248144
This seems like the same error..
They say that "The underlying OLE DB provider does not support the ADO record object."

It seems like you need to check the provider you are using to connect to Excel.

Did you try with the "Microsoft Jet 4.0 OLE DB Provider" If you build a connection string with the link propeties form, you should get a connection string that looks similar to the following:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls; Extended Properties=Excel 8.0; Persist Security Info=False

Please let me know if this helps you get going. If not please can you provide more information on the driver and connection string you are using.

Thanks and bye for now, Al

Hi Manoj!

I'd really move from Excel to a "real" database rather sooner than later, as the whole technology around "abusing" Excel as a database (incl. all drivers etc.) is highly instable and definitely not suited for serious production usage.

Maybe you should give MySQL a try, or if you don't need much concurrent users then the express version of MS-SQL Server are also suited well. Essentially, anything but Excel.

-regards,
Roland