I set up an external data query using the import feature. I selected a .csv file. It worked. When I right click and hit refresh, it pops up a window and i click import and it refreshes. But when I record the refresh process and try to play it back it doesn't seem to update??? The code doesn't error out but no data updated. What's wrong??

Here is the code the recorder spit out minus the select commands.

 Sheets("Coal").Activate
    Range("A2").QueryTable.Refresh BackgroundQuery:=False