query

[ehsas]

I have an excel file with 30000 rows which i want to be able doing my queries by using this files.I am trying to do by using the option run external data/run or create query from excel but I can't choose the file.Please if anyone could help.Regards,

 

[ehsas]

Could any one help please.Regards,

 

[stevebausch]

Give us your step-by-step, so we can see what are doing, and where you are getting confused.

The step-by-step will include keystrokes, menu selections, options chosen etc.

Right now, we have zero understanding of your process.

 

[ehsas]

i am selecting data-get external data.Here where I am confused what to be selected if i want to use my existing excel file as query.Regards,

 

[ehsas]

any help.
regards,

 

[PaddyD]

have you named the range in the source file?

see

http://216.92.17.166/board/viewtopic.php?topic=22483&forum=2&start=10

for a brief satep-by-step.

paddy