|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
02-11-2009
| #1 (permalink) |
| | Using SUM with ADODB object What am I doing wrong here? I expect to recieve a value that is the total for all values in the column 'TotalItems' from the spreadsheet server.xls. Instead, I get the error: "The Microsoft Jet database engine could not find the object 'MailServer'. Make sure the object exists and that you spell its name and the path name correctly." The code I am testing with is shown below. dbPath = "C:\desktop\Server.xls" con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath&";Extended Properties=""Excel 8.0;HDR=Yes;"";" rs.Open "SELECT Sum('TotalItems') as TotalItems FROM MailServer",con -- Scott A. Cooper |
My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Error using SUM() with the ADODB Object | VB Script | |||
| Using ADODB | VB Script | |||
| Re: Unable to cast COM object of type 'ADODB.RecordsetClass' to class type 'System.Object[]' | .NET General | |||
| ADODB: com and .net | PowerShell | |||
| Adding canonical aliases for Compare-Object, Measure-Object, New-Object | PowerShell | |||
