Import SQL data into Excel via ODBC, how to set auto refresh?

Use the RefreshPeriod property of QueryTables

Private Sub Worksheet_Activate()

Activesheet.QueryTables(1). p>

Thanks to the program you put the imported data in the worksheet to

The value of 15 can be adjusted, just enough to meet your update requirements on the line, take the value of 0-32767, 0 for the stop automatically refreshed.

The value of 15 can be adjusted to meet your update requirements.

What does not belong to the public security organs of the main source of data

List of big data books

Who knows the history of Lovecraft and why it caught fire? What is the success experience?

Debt treatment optimization, what is business legal advice

I need financial resources magical big data index, I looked for half a day can not find, someone to share Baidu.com disk?

The technology is the world's first, why Israel's agriculture can be so awesome

How about Rizhao Wu Jie Big Data Technology Co., Ltd.

How to check personal electronic health code

MD Dream Simulated Warfare 2 Can Alvin's kingship career be transferred to the ultimate professional hero or royal knight?

What is software engineering and how is it evolving?