Are you using Excel 2007 and Access 2007? Importing to Excel from Access?
Take a look at this John:
http://support.microsoft.com/default.aspx/kb/171850

ADO would probably be better for you:
http://www.erlandsendata.no/english/...batextimportwb

If importing from Access to Excel:
http://www.erlandsendata.no/english/...badacimportado

If importing from Excel workbook (to another Excel workbook):
http://www.erlandsendata.no/english/...dacimportwbado



HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

Maybe I explained in too much detail. Basically, I'm trying to get external
data from an Excel range in another workbook by clicking:
Data
Get External Data
From Other Sources
From Microsoft Query
Excel File
(Point to the file)
Then I get an error message:
"too few parameters"



"ryguy7272" wrote in message
...
I, for one, don't know what you are talking about. Can you please
describe
the scenario in more detail?

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"John" wrote:

I have 8 different workbooks that each have a worksheet called
CommissionDB.
I would like to periodically update those 8 worksheets from a master
database called Master.xlsm. I tried doing a "get external data/from
other
sources" from within the 8 workbooks, but get an error message "too few
parameters". Suggestions please?