SQL Excel

Hello,

I had installed the add in on Excel xp version and it was working great, but now i migrated on 2003 and is not working at all, i can connect and is blocking.and sometime i have the error about the xml file .Can you help me please

Hi

Sorry you are having the prob. There is no problem with Office 2003 and it has been tested alot but during your Office upgrade - something came up.

The first thing I would check would be your MSXML parser (this is the most likely cause of the problem..)

Here is a test routine (call it from Office VBA module) you could run to see if the parser is ok on your machine. If this routine fails you need to look into your installation of the msxml parser.
Code:

Code:

Sub TestMSXMLParser() Dim oXMLDoc As Object Set oXMLDoc = CreateObject("MSXML2.DOMDocument") Set oXMLDoc = Nothing End Sub

If you are not familiar with VBA - you need to paste the routine into a vba module (ALT F11, then use the insert from the menu to create a new module, and then select the empty module and then paste in the routine..) Then you could use the F5 key after selecting a line within the routine to run it.. If you get an error when this runs then you have a problem using MSXML parser from Office and you will need to investigate it. If this runs without any problem, the next time I would do would be to manually register the SQL Excel DLL (all Excel sessions need to be closed when you do this). It is in your C ProgramFiles SQL folder normally. You can use the regsvr32 command to register it. Please let me know if you need me to post up the exact instructions for that.. After reregistering, please see if the addin is fine.. If the above 2 things dont help you resolve the issue, I would have to suggest that you reinstall the addin (uninstall first..) Sorry for that, but this would be the easy way to get it working fine as it is not clear what happened during the upgrade. Please let me know how it goes when you can. Thanks, Al

Thanks for your response

I run the vba code no error for the execution, but i tried to register the dll
regsvr32 "C:\Program Files\SQL Excel\SQLExcel.dll" and it gived an error .Also a i waited a little bit long to have a connection and at last after 10 min i had one, but too long in comparison with excel xp version, curios.I tried on other computer and is doing the same think.

Hi !

Very sorry for this issue.

Please can you do a clean install (uninstalling from the control panel).

There is something weird going on here if you are getting an error when trying to register the DLL. Also strange that it connects but takes so long..

I think the easiest way to move forward would be a clean install. Sorry to ask you to do that but it will be the quickest way to resolve this I think..

Please let me know how it goes.

Alec