importing big dataset to stata 12 mp

[koukou limem]

hi
i am a beginner at stata 12 mp , i have a large data ( about 550 000 variables ) but when i try to import it from excel i have an error message , what dhould i do ???
thanks in advance

[Sergiy Radyakin]

You can save from Excel as tab-delimited or comma-separated, then import to Stata.

See also a response from Hua Peng (StataCorp) here, where an undocumented setting is revealed for such a case.
ODBC is another solution.

[Friedrich Huebler]

You can also save the file as an Excel 97-2003 workbook (.xls) and import that. The 40 MB size limit applies to Excel 2007/2010 files (.xlsx).

[koukou limem]

Friedrich Huebler i saved it as excel 97-2003 , the opening of the file was faster than before but the importation is unseccessful ( i got the same message ) should i change office 2003 ?

[Friedrich Huebler]

Please say exactly what you typed and exactly what Stata typed (or did) in response.

[koukou limem]

i typed file=>import=>excel spreadsheet then browse and i get this :

[koukou limem]

Sergiy Radyakin i tried but no result

[Sergiy Radyakin]

Sergiy Radyakin i tried but no result

Do you mean to say that you have tried to save the file as a tab-delimited file, and then tried to import it to Stata 12 and there was "no result"?
What I posted was 3 (three) distinct ways. Which one did you try? What did you type? What was Stata's response?

[Sergiy Radyakin]

Also, clarify what is your Excel file. You wrote that it has 550,000 variables. Excel files may not contain so many columns (Excel limits).

[Friedrich Huebler]

Sergiy asked good questions. Another mystery is why you are getting a message about an XLSX file when you are trying to import an XLS file.

[koukou limem]

sorry i mean the file has 550k observation , i save it at the first as excel 2003/2007 then as Friedrich Huebler avised me , i saved it as excel 97/2003

[koukou limem]

Sergiy Radyakin i used your second method , i saved alsso the excel file as csv , the importation ( using insheet) is done but when i see the sata in stata i get all the values il the same column like this :

[koukou limem]

any suggestion please

[Hua Peng (StataCorp)]

Friedrich Huebler said :

"You can also save the file as an Excel 97-2003 workbook (.xls) and import that. The 40 MB size limit applies to Excel 2007/2010 files (.xlsx)."

This restriction was removed in Stata 13 hence it is still in effect if you are using Stata 12. As Sergiy Radyakin pointed out, you can use

 set excelxlsxlargefile on

to bypass the restriction. Although be prepared for the possible side effects described in http://www.stata.com/statalist/archi.../msg01157.html


Hua

[koukou limem]

it's blocked when i used the code :
set excelxlsxlargefile on