Skip to content

Simple Excel VBA

Make your office life easier with simple and fast Excel VBA solutions.

  • Home
  • Posts
  • Videos
  • Memes
  • SAP VBA
  • My music
  • About me
  • YouTube
  • Facebook
  • Buy me a coffee
  • Pinterest
Simple Excel VBA

Tag: how to query Excel data using SQL in VBA

How to SQL query Excel data in VBA?

There are tons of ways to get the data from Excel worksheet. This one might be not so obvious at the first glance. In this article I’m going to show You how to query Excel data using SQL in VBA.

Continue reading “How to SQL query Excel data in VBA?”
Author Tomasz PłocińskiPosted on 09/09/202221/09/2022Categories Excel VBA, SQLTags ADODB in VBA, how to query Excel data using SQL in VBA, how to SQL in VBA1 Comment on How to SQL query Excel data in VBA?

Search for article

Categories

  • Arrays
  • Charts
  • Excel
  • Excel VBA
  • http
  • Internet Explorer
  • Outlook
  • PDF
  • PowerPoint
  • Python
  • SAP
  • SQL
  • VBE
  • Video
  • Web automation
  • Word
  • XML
  • Home
  • Posts
  • Videos
  • Memes
  • SAP VBA
  • My music
  • About me
  • YouTube
  • Facebook
  • Buy me a coffee
  • Pinterest
Simple Excel VBA Proudly powered by WordPress