I used to use an application, which creates an SQL Query that exports all Tables of a Database to an Excelsheet. It worked very good for a long time (I worked with MS SQL Server 2005 and MS SQL Server 2008 R2). As an Office Suite I worked with MS Office 2003 and I had Windows XP.

Now, I work on a new computer with - MS SQL Server 2008 R2 and- MS Office 2007- Windows 7

And the skript does not work anymore. I am not able to find the root cause of the problem (I am not the developer person but the user and therefore I only have basic know how in SQL and T-SQL).

My skills at German are rather limited - I know just two words Einfahrt and Ausfahrt, and that too only because I see that on every highway. So the meaning of the error messages may have been lost to me in translation.

That seems correct. Print out the @conString after the set statement and see what it is, and compare to the connection strings on this page (which is for Access 2007) http://connectionstrings.com/access-2007 Then, if it displays an error while trying to create the file, can you post the exact error message?

Are you on a 64-bit windows? Is SQL Server 32 or 64? I know there are issues related to this with ACE drivers, but not familiar enough with the details. Post whether you have 64 or 32, that would help others who may be more familiar with the issue to respond appropriately.

Hello guys..When people install the window XP and after that installation driver on the window XP is 64-bit then error is occurred.At this situation Excel sheet create problem.Just install the suitable driver with the window then error is automatically disappeared.