Dear all,
I have a major problem importing data from an excel sheet into Stata - specifically I get the r(198) error, which is not particularly helpful.

The following command is being used:
Code:
import excel using siena.xls, firstrow sheet(Vorstand) cellrange(A1:EW1086)
Here's the thing: I tried this exact code on an excel sheet that has the exact same structure, but less columns and rows (only about 10 each). It imports flawlessly. When I try to import it via "Import - Excel spreadsheet" and select "first row as variables" it gives me the same error, but when I click "import all data as strings" it imports the data without question. However, the rest of my code does not work like this as it expects the data to be formatted as "date/time" and I don't see why Stata wouldn't just import the file as it is.

It seems to me that either Stata can't handle the file size (unlikely - it's about 3MB) or there is something wrong with the Excel sheet. Unfortunately I have no idea what that could be as the format is exactly the same in my test sheet (which worked).

Any ideas on how to solve this?

Thank you so much in advance - I've got an important meeting next week and thought I was on the safe side trying the code with a smaller subset of my data. Major mistake as it turns out.

edit: This might be important - I'm using Stata SE 12.