Vista - Problem using SUM with ADO object

02-11-2009

What am I doing wrong here? I expect to get the total for all rows in the
column 'TotalItems' of the spreadsheet server.xls but 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." I do get results when using "SELECT * FROM
MailServer" so it must be the SUM().
Thank you.

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

02-12-2009

Scott,

I assume that the MailServer in the SQL is the worksheet name in which case
it should
be written as follows
[MailServer$]

Paul

"Scott" <Scott@xxxxxx> wrote in message
news:514F0722-56A0-4D7A-A1D7-69752C7B158B@xxxxxx

Quote:

> What am I doing wrong here? I expect to get the total for all rows in the
> column 'TotalItems' of the spreadsheet server.xls but 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." I do get results when using "SELECT * FROM
> MailServer" so it must be the SUM().
> Thank you.
>
> 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
>
>
>

02-11-2009	#1 (permalink)
Scott n/a posts	Problem using SUM with ADO object What am I doing wrong here? I expect to get the total for all rows in the column 'TotalItems' of the spreadsheet server.xls but 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." I do get results when using "SELECT * FROM MailServer" so it must be the SUM(). Thank you. 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
My System Specs

02-12-2009	#2 (permalink)
Paul n/a posts	Re: Problem using SUM with ADO object Scott, I assume that the MailServer in the SQL is the worksheet name in which case it should be written as follows [MailServer$] Paul "Scott" <Scott@xxxxxx> wrote in message news:514F0722-56A0-4D7A-A1D7-69752C7B158B@xxxxxx Quote: > What am I doing wrong here? I expect to get the total for all rows in the > column 'TotalItems' of the spreadsheet server.xls but 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." I do get results when using "SELECT * FROM > MailServer" so it must be the SUM(). > Thank you. > > 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 > > >
My System Specs

Similar Threads
Thread	Forum
Problem in returning an object from a function	VB Script
Object Dock problem	Software
Object lifetime/event problem	.NET General
Problem with Measure-Object on get-process	PowerShell
Adding canonical aliases for Compare-Object, Measure-Object, New-Object	PowerShell