To avoid this, we have a process in VBA, with that, we can convert the excel file into a text file without harming the data. Although it is not a big task to when it is a repetitive activity and may take huge time to perform. For this, we need to convert the excel file into a text file. The text file doesn’t get hanged and we can store as many data and tables into a single text file without crashing the file. Extracting the data from the database is possible if use text file for this purpose. This kind of situation we have seen in many projects where we need to extract the data from the database. Due to this we could neither work on that file nor saving the file into excel format. We all come across with such kind of situation where we had to put huge data in excel files, but eventually, we have faced the situation when the size of that file with the huge data went so up that we had to convert that into a text file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |