Forum Discussion
VBA: How to read very very big csv file into excel quickly without excel's auto formatting?
When I use `Workbooks.open` method to open the csv file I want to use, it takes me 30 seconds. However, Excel foramtted the data automatically during file opening. It formats some values like date, ...
Use power query connection only option by way of creating connecting to csv file.
https://excel.officetuts.net/examples/open-large-csv/
https://excel.officetuts.net/examples/open-large-csv/
Thanks for the possible suggestion.
However, I need to load all the data at once since I will later use other macro to edit them.
The link looks like load the data dynamically, which is not what i want to do.
However, I need to load all the data at once since I will later use other macro to edit them.
The link looks like load the data dynamically, which is not what i want to do.