We help IT Professionals succeed at work.

Excel VBA: Import CSV. No Data Conversion

140 Views
Last Modified: 2018-12-18
What is the fastest and most compatible VBA code needed to import data from a .CSV file titled: "Hello.csv" to "Sheet1" where the code assumes all data in all columns is a string. If possible, do this without an .ini file and without opening the .csv.
Comment
Watch Question

ste5anSenior Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
My last question was very specific. (i.e., Microsoft text driver only.) I was wondering if there was some other way that would allow it, such as querying the file using SQL etc.
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thanks guys!
Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome!