VBA: Pulling MS SQL data to text file

I would like to post this thread (kinda different topic) regarding a reply in previous thread: https://www.excelforum.com/excel-pro...-database.html

How to use VBA to pull data into text file? I was able to use below code to pull data from MS SQL to excel sheet, however, sometimes there are multiple millions of records (or I don't want to make excel file size too large, just use a text file as data source), how can I modify the code and pull data into text file (using below folder path)?

From the text file, how can I use VBA (SELECT *** From Text_File Where ColumnName = ***) to pull data from text file to excel sheet?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am using UTF-8 non BOM csv files.
This function return the saved file path.

Please Login or Register  to view this content.

Thank you very much, it looks a lot more complicated than pulling data to excel sheet directly, but that is what I want to learn.

However, for the second part of my post (From the text file, how can I use VBA (SELECT *** From Text_File Where ColumnName = ***) to pull data from text file to excel sheet? ).

Text file is just data source for now, how can I pull some of its data from text file to excel sheet? I would like to pull a little data from text file to each of excel sheet, and there could be around one thousand of sheet. https://www.excelforum.com/excel-pro...-database.html

For example, I want to run SELECT * From TextFile Where Group = 1 , then put the data in Sheets("Home").Cells(1,1) , how to do that?

You could use an IN clause to filter by multiple values at once, or use a join or subquery.

ChatGPT Question: How to use VBA to write MSSQL table data to text file?

Code from chatgpt, wonderful.

Please Login or Register  to view this content.