open the csv file and merge them into sheet

Hi all member forum.
I worked in one of the main private banks in my country,I want to use excel macro to simplify my work, because I am still learning about this Excel VBA, I want to ask something :
1. How and what yah VBA syntax we use if we want to process the data from csv file and line number of the file exceeds the capacity Ms.Excel (more than 1,500,000). I want to break down the contents of the file into multiple sheets. to the number of rows excel currently 1,048,576, now my data exceeds the number of rows. I want to move the rest of the excess data sheet to the next row in another sheet (using macros). please enlightenment ...

2. How and what VBA syntax we can use if we want to process the data from csv file where there are multiple csv files (each file has a number of different lines) and the files we will combine into 1 in the excel sheet. exmple : I have 3 csv files, three files I want to combine into one sheet in Excel using macros.

please anyone can help me to this case..
thank you.

Hi JBeaucaire,
thank you for your enlightenment. i'll learn n try from that link from your post. i hope, more expert with macro after this. thank you

I've followed your advice as above, for free utility to split a csv file that column so much can already do well. Then, for the macro code related to open the csv file (csv import file) and put it into a sheet in the workbook can also be done (macro code can run well), but the macro code can work well if its csv file limited by "comma" (separated by coma). If the csv file it in the limit with the "~" (no comma), then the macro code is still running but the results are not as desired (the result of irregular data columns), whether there should I add to the macro code? Please advise and help again. many thanks

Hi JBeaucaire

sample csv file (2 file) already inserted in this thread . would you inform me about this case? thank you for your attention and suggestion

Hi JBeaucaire

my sample workbook is delimiter or sparated by " ~ " (no comma or sapce). please kindly help. thank yo

I'm sorry for late reply,
I've been using macro code from you as above, and can run well. Thank you for your help, you are very expert in such matters. Thank you once again J.
please kindly guidance me again if later I have more questions.
greetings
Dolphino