Recent content by floridagunner

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