In addition, EXCEL's handling of big data is extremely limited. Without data analysis, statistics and query, fortunately, once these tasks are completed, EXCEL will basically die. So, if you know Access, you'd better import it into Access. Here are two.
If you have to import EXCEL, the best way is to open DBF files with VFP and divide them into dozens or twenty small DBF files (this separation with VFP should be very simple, that is, you can complete the copy command of data records), and then open these files directly with EXCEL and save them as EXCEL files. This is three.
If none of the above answers can help you, there is no way.