Actually Rstudio can manage that size of file, the real limitation would be your systems memory RAM, even if you split your file, if you still need to load them all in memory at the same time you will have the same issue at the end.
Try to rephrase your problem as a REPRoducible EXample (reprex) so other people can see what specific libraries or approach are you using, and maybe they can give you better help.