This is what I meant by "almost makes sense" - at least data import is
located on the data tab. Sorry for creating the confusion earlier.
Sometimes things make almost no sense, such as having worksheet protection
under Format -- Cells.

"Joe L" wrote:

Thanks Gord yes this works (but a strange place why is it existing in wonder)
well in any case it worked
re my other comment I am new to this and see many poorly phrases questions
(if you look for help can u not spent 5 minutes phrasing the question) so
sorry if I ruffled any feathers as I though the comment was referring to my
question
Joe

"Gord Dibben" wrote:

On Data Tab I see Get External Data section.

From Access, Web, Text, Other Sources and Existing Connections.

To import a table from another Excel file click on Existing Connections.

You will most likely have to browse to the workbook.table and OK


Gord Dibben MS Excel MVP

On Mon, 8 Mar 2010 12:24:01 -0800, Joe L
wrote:

Hello All,
In Excel 2003 I used to use DATA - IMPORT EXTERNAL DATA - GET DATA and a
dialogue box would start and I could import another Excel file (well table in
the file) into the file I have open
I cannot see this feature in Excel 2007 (I can see IMPORT FROM ACCESS,
IMPORT TEXT)
Anyone know where it is?
Thanks for any suggestions

Joe L

.