Re: Debug, Please help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Can you show a sample of the SQL that you are referreing to? Maybe record a
macro while manually creattig the table and posting the code.

"Michael" wrote:

On Aug 20, 5:04 pm, Michael <michae...@xxxxxxxxx> wrote:
Hi,

Could anyone please help with the following code. When I ran it, it
said: "Error 1004"

ActiveSheet.PivotTableWizard SourceType:=xlExternal,
SourceData:=Sqlstring, tablename:="Table1"

Thanks a lot!!

Michael


I figured out the code now. Now Could anyone please post some code
when I wanan change the SQL in an existing pivottable to get it
refreshed? Thanks a lot. Mike


.

Relevant Pages

  • Re: Connection to SS 2000 failing
    ... sort needs to spill to disk c) a hash needs to spill to disk, ... Some other processes is hogging your system, and the posting of the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.connect)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.queries)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.macros)
  • Re: Microfocus & Oracle data types
    ... Thanks, Robert. ... SQL is fairly new to me ... ... > Top posting ... > Hello Michael ...
    (comp.lang.cobol)
  • Re: Select question
    ... Posting CREATE TABLEs, INSERTs for sample data and expected ... do have in common: SQL. ... >but if table is derived you can't create the same query ... still find SQL Server's optimizer producing odd-looking plans. ...
    (microsoft.public.sqlserver.programming)