stop ODBC connection from getting deleted

[tlindeman]

I have the following code:

Sub Clear_SQL()
'
' Clear_SQL Macro
'

'
Sheets("SQL Results").Select
Columns("A:H").Select
Selection.ClearContents
Sheets("Summary").Select
End Sub

What is happening is it is deleteing my ODBC link to the SQL database. How do I clear out the data on this tab without deleting the ODBC link?

Thank You
Tony

 

[xenou]

Clearing the cells that contain a querytable also deletes the querytable. Typically when you want new data in a query table you "refresh" the table - there shouldn't be a need to clear the cells this way.

ξ

 

[tlindeman]

thank you , I was not thinking however that makes complete sense. Thank you for your help.

Tony