HELP! Copy Access data to Excel Error
-
Hi ~ I have an MFC application using automation that needs to open an access database, perform a query to get a recordset and then copy the recordset to Excel. I found an article on the microsoft site that explains how to do it, but I am getting an error = "The server threw an exception" The article is at: support.microsoft.com/kb/243394/en-us I am using Visual C++ 6.0 and Excel/Access 2003 (although my file is Access 2000 format). Any ideas on what I might need to do to fix it? Thanks so much for your help! Jen
-
Hi ~ I have an MFC application using automation that needs to open an access database, perform a query to get a recordset and then copy the recordset to Excel. I found an article on the microsoft site that explains how to do it, but I am getting an error = "The server threw an exception" The article is at: support.microsoft.com/kb/243394/en-us I am using Visual C++ 6.0 and Excel/Access 2003 (although my file is Access 2000 format). Any ideas on what I might need to do to fix it? Thanks so much for your help! Jen
Have you single-stepped through the code to find which statement is throwing the exception?
"The largest fire starts but with the smallest spark." - David Crow