Search results for query: *

Should I just go ahead and delete Sheet 3 and Start the Database queery again? This is what it did in Sheet 3 by the way: Pool Unique FA FC Email It seems to have deleted the Column (FA Split Master Lookup) and bought back data for the first 2 columns

Sheet 1 Headings: A B C 1 (Pool Unique FA) (FC Name) (FC Email) 2 1234567 Smith, John jsmith@hotmail.com Sheet 2 Headings A B FA Split Master Lookup 6582461 Did you read my post...

When I tried to refresh the data An error message came up saying [Microsoft][ODBC Excel Driver] Missing),],or item in queer expression`sheet 1$`.Pool Unique FA`='sheet2$`,`AccountList`

What do you mean by that: "Its Log

Ok this time it ran the Macro and here is the code: Sub GetData() ' ' Macro1 Macro ' Macro recorded 07/17/2007 by Adeel Khan ' Dim sSQL As String sSQL = "SELECT" sSQL = sSQL & " `Sheet1$`.`Pool Unique FA`" sSQL = sSQL & ", `Sheet1$`.`FC Email`" sSQL = sSQL & vbCrLf...

Is it possible that this is happening because that was how the original Database queery was run? Just a guess right now I dont even remeber what the criteria was that I used. Thanks

This is the Code that I have: Sub GetData() ' ' Macro1 Macro ' Macro recorded 07/17/2007 by Adeel Khan ' Dim sSQL As String sSQL = "SELECT" sSQL = sSQL & " `Sheet1$`.`Pool Unique FA`" sSQL = sSQL & ", `Sheet1$`.`FC Email`" sSQL = sSQL & vbCrLf sSQL = sSQL & "FROM...

[auto_open] < [SetupFunctionIDs] < [SetupFunctionIDs] > [PickPlatform] < [PickPlatform] > [VerifyOpen] < [VerifyOpen] > 1 [RegisterFunctionIDs] < [RegisterFunctionIDs] > [auto_open] > SELECT `Sheet1$`.`Pool Unique FA`, `Sheet1$`.`FC Email` FROM `H:\My Documents\Book1`.`Sheet1$` `Sheet1$`...

No the heading in (Sheet 2, A1) is FA Split Master Lookup Thanks

[auto_open] < [SetupFunctionIDs] < [SetupFunctionIDs] > [PickPlatform] < [PickPlatform] > [VerifyOpen] < [VerifyOpen] > 1 [RegisterFunctionIDs] < [RegisterFunctionIDs] > [auto_open] > SELECT `Sheet1$`.`Pool Unique FA`, `Sheet1$`.`FC Email` FROM `H:\My Documents\Book1`.`Sheet1$` `Sheet1$`...

An error message came up saying [Microsoft][ODBC Excel Driver] Missing),],oritem in queer expression`9sheet 1$`.Pool Unique FA`='sheet2$`,`AccountList`',

Yes The Column in Sheet 1 that contains the account number is Pool Unique FA.

The queery table was on Sheet 3

Ok I ran this updated code in Sheet 4 and I got an error message saying SQL syntax error When I pressed Debug the following code was highlighted: .Refresh BackgroundQuery:=False

But do I run this code in Sheet 3 or Sheet 4? Thanks

When you ask: "What key value is common to both"? Do you mean what criteria I used?

Sorry that was: With Sheets("Sheet4").QueryTables(1)

Ok I guess my computer did not crash. I got back an error: A box popped up saying (Runtime error '9') Subscript out of range. I then pressed the debug button and the following code was highlighted: [code]With Sheets("Sheet4").QueryTables(1)[code]

Oh Shiiiit. Do you mean I was supposed to do this only for 5 Account numbers??? Like an initial test??? I just ran the Macro on the whole file and it looks like it may crash my computer. The CPU usage has shot up to 90%. I think I prefer this: sSQL = sSQL & "WHERE (`Sheet2$`.`FA Split...

Is this also part of the code: 'assuming that you have a named range name AccountList with each account number listed once...