Hmmm...I don't seem to have a "import data" option, but instead a "microsoft query" option that allows me to import data from other databases - including Excel. Unfortunately, I am ignorant of microsoft query. Why is it that in every other MS app there is an "import data" option, but not in excel. nevermind, I know the answer and his name starts with Bill.
Still working on it...
thanks!
Alarik
Quote:
geoschmo said:
You might also try creating a new excel workbook, and then on the data tab click Import external data|Import data. Browse to your excel file you are having trouble with. It should then give you a list of the worksheets in that workbook without actually opening the entire workbook. It might still give you memory problems, but it might work. If it does you can save each worksheet as a separate workbook then.
|