My data exceeds the stata maximum limit. Is there any option to accommodate the whole data in stata?

[Sadam Khan]

Hello Stata Experts.
I have an excel file of almost 8GB with large data set. Stata does not upload the file saying that the data is large and above Stata's maximum limit. Is there any option to accommodate the whole data in Stata? Kindly guide me with your expertise. The screenshot of the notification is attached below. Thank you in anticipation.

[daniel klein]

import excel allows you to specify only certain variables (columns) to be imported; there is also a cellrange() option that imports only part of the Excel file. Your best bet is to split the Excel file into two or more chunks, then append or merge the files in Stata.

[Joro Kolev]

If you think that you have enough RAM to carry out this operation, another way is to export the file firstly to comma delimited (.csv) or tab delimeted text file, and then try and import this file.

[Rich Goldstein]

note that this is a limit that Stata places on -import excel-, not a Stata problem: from the manual: "For performance, import excel imposes a size limit of 40 MB for Excel 2007/2010 (.xlsx)
files. Be warned that importing large .xlsx files can severely affect your machine’s performance."